Document a .xla file

[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.

 

[Juan Pablo González]

Change the IsAddin property of the ThisWorkbook module to False.

 

[Guest]

Hi Juan,

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

Thank you for your concern.

 

[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.

 

[Guest]

Thank you for our help, Juan Pablo. I really appreciate it.

 

[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

 

[Guest]

Good point. Thank you Ivan.