export VBA code in forms, modules and reports

[John B. Smotherman]

I'm wondering if there's an automated (ie, using VBA) method to write the VBA
code that underlies my forms and reports to a text output file, external to
the database. For example, if I have a form called frmItems that has a
module, is there a way I could create a file called "frmItems_vba.txt" that
would have the VBA code from the module associated with the form? Thanks!

 

[Douglas J. Steele]

Take a look at the undocumented SaveAsText method.

I talked about it in my February 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can read it online at
http://www.vb123.com/kb/200502_ds_saveas.htm or you can download the column
(and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[John B. Smotherman]

Outstanding! Thanks, Doug. I knew I'd seen something about it SOMEWHERE...

 

[Mackster66]

You could use the built-in Documenter. Go to Tools>Analyze>Documenter. Go
to the Forms tab and select all and then click on the Options button. Select
Code on top and Nothing on the bottom and deselect the others. Go to the
Reports tab and click on the Options button. Select Code ont top and Nothing
on the bottom and deselect the others. Go to the Modules tab, select all and
then click on the Options button. Select Code and deselect the others.

Click the OK button and it will prepare the report. It may take a few
minutes if you have an extremely complex database. When it is complete,
select File>Export and export it as a .txt file.