List all code in workbook?

J

J.W. Aldridge

Is there are code that would allow me to list all codes within a
workbook?

I need all of the actual codes (sub, private subs, worksheet/workbook
change events, etc).

I found several that just lists names of them all. However, I want the
entire code.

I am trying to create a backup list of all of my codes that i've
gathered, solicited, and or created over the years from various
workbooks.

Perhaps copying them directly to word or notepad would be a good
option.


Thanx
 
C

Charlotte E.

Why not just export the modules into a library folder on your harddrive???
 
J

J.W. Aldridge

Charlotte,

If you have details on how to, I'd try it.


Thanx Nigel,
That gets me off the ground.
 
J

JLGWhiz

If you copy them to Word, I suggest doing it in plain text, otherwise you
will have a big formatting problem to get your indents and line wraps
straightened out. If you copy to Notepad, the indents are pretty much
maintained but line wrap can also be a pain there. I saw some code somewhere
that copied the main module procedures, but I don't recall seeing any that
would pick up forms' and controls' underlying codes. It doesn't take that
long to copy anyhow. Useer forms and controls will take the most time. The
project module and sheet modules are a snap.
 
S

shg

Charlotte said:
Why not just export the modules into a library folder on your
harddrive???
Click to expand...
J.W. said:
Charlotte,

If you have details on how to, I'd try it.
Click to expand...
If you use 'VBA Code Cleaner'
(http://www.appspro.com/Utilities/CodeCleaner.htm), it will save all the
modules in a file you specify. You can open them in Notepad (or anything
else) and print them. And you get your VBA project cleaned in the
process.

Remember to set a fixed-pitch font before printing.
 
C

Charlotte E.

Just right-click on a Module, and 'Export'

This will save the VBA code as a simple text-file with the suffix .BAS.


CE
 
Top