View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Beckinsale Michael Beckinsale is offline
external usenet poster
 
Posts: 80
Default 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