Chrissy,

Change the IsAddIn property of the XLA workbook to False so that it becomes
visible in Excel, and then run the code documentor. Then, set IsAddIn back
to True. Yes, it works fine in Excel XP.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Chrissy" wrote in message
...
I like that Documentor BUT ...... I want to document an XLA and, unless
I missed something, I don't think I can.

Another thing - does it would on Excel XP as I usually run that but do not
have it running now to test.

Chrissy.

David McRitchie wrote
Sorry that was an old link for Rob Bovey's use this one instead:

Excel VBA Code Documentor
http://www.appspro.com/utilities/Documentor.asp

The Excel 97 Code Documentor automatically documents the "vital
statistics"
of your VBA project. These statistics include:
A complete procedure listing for all modules in an outlined worksheet
A summary of the number and type of VBComponents used in the project
The number of procedures in the project, both total and per VBComponent
The number of DLL declarations in the project, both total and per
VBComponent
Total lines of code in the project and per VBComponent
Module file size for each code module