I have a complex addin that I modify frequently. I'd like to be able to
make changes while using it, and then directly save a modified addin.
I've successfully written VBA code that turns the modified addin into a
workbook, and I can save that workbook, reopen it, and then save it as
an addin. But if I try the shortcut of saving the workbook directly to
an addin using Workbook.SaveAs FileName := S FileFormat := xlAddin, the
file saved is always a workbook, not an addin, regardless of whether
filename S includes a .xla extension.

This is in Excel 2001 on a Mac running OS 10.3.3.

Any ideas?

Thanks,

Dave Ring