save file as addin programatically

[Bura Tino]

Hi,

I can't figure out the vba for this and recording a macro does not work. How
do I programatically save a workbook as an add-in with a specified name in a
specified directory? (Trying to avoid the pain of going through Save As...
and navigated to the desired location.)

Thanks,

Bura

 

[Bob Phillips]

Bura,

Give this a whirl

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Bob\Application
Data\Microsoft\AddIns\myAddin.xla", _
FileFormat:=xlAddIn

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)