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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling a worksheet calculate event in XLA code 4
XL03 suppress 'missing XLA' msg on Workbooks.open 0
force to use a specific XLA 4
Load Macros from xla on open 3
Outlook to use procedures written in Excel VBA 0
XL2003 working with an XLA and two separate workbooks 0
Sample VB6 project for creating an Excel Addin with a button? 2
Open and Enable xla file from vba code? 1

Top