How to export VBA source code as text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 22 Jan 2008 21:53 GMT

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

Reply to this Message

Douglas J. Steele - 22 Jan 2008 23:12 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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
[quoted text clipped - 6 lines]
> Thanks in advance,
> Rick

Reply to this Message

Rick - 23 Jan 2008 14:28 GMT

Doug

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

Rick

Reply to this Message