How to export VBA source code as text

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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

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

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export VBA code in forms, modules and reports 3
Word to Excel: Export comments with text and line number 0
How to Export VBA Code to a text file 2
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Export VBA Code to Text File 4
VBA surprise 2
how do i delete a text file using ACCESS VBA code 8
How to open pdf from VBA 2

Back
Top