VB Project Documentation

[Michael Beckinsale]

Hi All,

I have found some utilities on the web which produce a report of the
contents of Excel workbooks and VBA modules etc. However none of them
actually list the VBA code contained in the ThisWorkbook & Sheet Objects or
code Modules.

Does anybody know if a utility exists and where to find it ?

Alternatively can anybody provide code to search ThisWorkbook & Sheet
Objects and code modules. Then if code exists, copy and paste the code into
a new worksheet ?

I know l can print from the modules directly but it would be nice to be able
to produce a "Technical Specification" for each of my products.

All comments greatfully received

Regards

Michael Beckinsale

 

[Tom Ogilvy]

The code at

http://www.cpearson.com/excel/vbe.htm

doesn't do specifically what you ask, but certainly provides sample code to
roll your own.

 

[Michael Beckinsale]

Tom,

Many thanks.

The link you provided has certainly pointed me in the right direction but
l'm beginning to think it might be a bit beyond my capabilites. However l
shall "give it a go"

Regards