List all function, properties and classes

[theta]

Hi all...

I have just inherited a new product to manage. It is based within Excel VBA and contains a few thousand lines of code, spread across several workbooks (with references back to a main workbook) and several modules.

Almost everything has been broken down to custom functions and class modules.

Is there a VBA macro I can run to summarise all :

1. Functions contained within every module
2. The object/class tree e.g. function1.property1

Then I will effectively have a reference guide to work from. As everything is custom there is no reference.

[Bob Phillips]

Get hold of a copy of MZ-Tools, it is free, and has such functionality I believe.

[theta]

Thanks I will give it a try :) I was looking at the following. It has been designed to run within the workbook containing the code. Any way I can just produce a basic workbook with this in and access the workbook to be analysed using the file open method?

What would be the most efficient way to acheive this?

http://msdn.microsoft.com/en-us/library/dd890502(v=office.11).aspx

[theta]

Wow... MZ_Tools documentation utility is unbelievable! Thanks for this info :)