How to export VBA source code as text

[Rick]

I have an Access 2003 application with over 100 VBA code modules.
Short of calling up each one in the VBA interface and ^A^C then ^V to
a text editor, is their a faster way to dump all the source code into
a text file on disk?

The "print-to-file" feature appears to create a massive file of laser
printer commands, which is not usable.

Thanks in advance,
Rick

 

[Douglas J. Steele]

Look on the File menu: there's an Export module option.

There's also an undocumented SaveAsText command you can use. Check my
February, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Rick]

Doug

The "Access Answers" database does exactly what I want. Thanks a
million.

Rick