VB Project Documentation
 

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

VB Project Documentation
 

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.

--
Regards,
Tom Ogilvy


"Michael Beckinsale" wrote in message
...
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

VB Project Documentation
 

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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"Michael Beckinsale" wrote in message
...
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