make xla from xls using VBA

E

ed

I'm stuck on that one at the moment.

I have an .XLS file in which i added a commandbar option to "Install as XLA"
It triggers a VBA code which should do all necessary steps to create the XLA
file (= the XLS Saved As .XLA when done manually) inside the UserLibraryPath
and activate it in the Add-Ins list.

All in Excel 2002

Any link to a how-to or sample code for it ?

Thanx.
 
Top