Outputing Excel Module Codes
 

Is there a easy way (code) to output all the codes in a
given project to a file (for Excel 2000) ? I am presently
doing it semi-manually via the "file export" command
available in Excel visual basic editor with the help of a
sendkey code ! Still not effective and clean.

Outputing Excel Module Codes
 

Leo,

See the "Exporting All File In A Project" section at
http://www.cpearson.com/excel/vbe.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Leo" wrote in message
...
Is there a easy way (code) to output all the codes in a
given project to a file (for Excel 2000) ? I am presently
doing it semi-manually via the "file export" command
available in Excel visual basic editor with the help of a
sendkey code ! Still not effective and clean.