View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jac Tremblay[_3_] Jac Tremblay[_3_] is offline
external usenet poster
 
Posts: 30
Default Document a .xla file

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

"Juan Pablo González" wrote:

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.

--
Regards

Juan Pablo González

"Jac Tremblay" wrote in message
...
Hi Juan,

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

Thank you for your concern.

"Juan Pablo González" wrote:

Change the IsAddin property of the ThisWorkbook module to False.

--
Regards

Juan Pablo González

"Jac Tremblay" wrote in message
...
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.
--
Jac Tremblay