Hi. I'd like to ask how to create new AddIn with my own macros. It is
easy in Excel: File - Save as ... (ms addin).

BUT I want to do this with help of another macro. I tried this:

ActiveWorkbook.SaveAs _
Filename:="C:\MyMacros\MyAddin.xla", _
FileFormat:=xlAddIn
ThisWorkbook.IsAddin = True

but it doesn't work - there is something wrong with file MyAddin.xla.

Can you help me to create correct AddIn ba macro? Thanks for help,
jiri.
Excel 2002


--
antelao
------------------------------------------------------------------------
antelao's Profile: http://www.excelforum.com/member.php...o&userid=31039
View this thread: http://www.excelforum.com/showthread...hreadid=507572