Exporting VBA Code from Access2000

  • Thread starter Thread starter kansaskannan
  • Start date Start date
K

kansaskannan

How do I export the code (from modules, from many controls on forms),
from one Access 2000 database? I would like to capture all the code in
a text file. Thank you.
 
One approach would be to use the Documentor (Tools>Analyze>Document). Select
Forms, Reports, Modules, etc. For each group, select Options and uncheck
everything but "Code". Once it runs you'll get a report in Access that you
can Export in .rtf file format, which can be opened in Word, Wordpad, etc.
The listing can be huge and (in my experiece) the documentor has a tendency
to crash if the report is too big (too big being very subjective). If that
happens, try breaking the workload into smaller chunks.

Another approach is to export modules individually from the VB editor into
separate .txt files (File>ExportFile or right click on a module in the
Project Explorer and select Export File). Then you can open up Word and use
Insert>File to load them into a single document (be careful that your
insertion point is at the end-of-doc when invoking Insert>File).

One difference between the 2 methods is that the documentor adds Line
numbers to your code listing. Manually exporting modules does not.

I know there are 3rd party tools that can also provide code listings (Access
Analyser from www.FMSInc.com, for one).

HTH,
 
Back
Top