theta
04-11-2012, 01:48 AM
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.
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.