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

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

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


"Rick" <nn0410@optonline.net> wrote in message 
news:b0e48de9-7f47-4a82-a69a-7a945fa8e0b5@d4g2000prg.googlegroups.com...
>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 

Doug

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

Rick