save file as addin programatically
 

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

save file as addin programatically
 

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)

"Bura Tino" wrote in message
...
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