Document a .xla file

G

Guest

Hi everyone,

I have an addin that contains over 20 modules and about 24000 lines of code.
I would like to document it with Rob Bovey's Code Documentor but I can't
because there is no Excel workbook open.

How can I convert this .XLA to a .XLS so I can run the application?

Thany for your help.
 
G

Guest

Hi Juan,

How do I access this property and how do I change it?

Thank you for your concern.
 
J

Juan Pablo González

While in the VBE, press Ctrl R to show the Project Explorer. In there,
browse to your xla, and then select the "ThisWorkbook" module. When you
have it selected, press F4 to display the properties. In there you'll see a
list of the properties available. Change the 'IsAddin' from True to False.
 
I

Ivan F Moala

Just to Add to this..... don't forget to set it back to True and sav
it.
Save this while in the VBA Editor. ie. File > save... or use the sav
icon
 

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

Top