printing VB macros

[Slowconn]

Is there any way (i.e., a macro or builtin) to print all the macros in a VB
project? Or to copy them to a Word file? (Particularly where there are many
modules and it’s a bit of a pain to copy and paste all the modules into Word
manually.) I’m using Word 2003 at the office, but Word 97 at home.

 

[Karl E. Peterson]

Is there any way (i.e., a macro or builtin) to print all the macros in a VB
project? Or to copy them to a Word file? (Particularly where there are many
modules and it’s a bit of a pain to copy and paste all the modules into Word
manually.) I’m using Word 2003 at the office, but Word 97 at home.

Maybe use a code cleaner[1] to export all the modules, then load'em up and print'em
from somewhere?

[1] http://word.mvps.org/FAQs/MacrosVBA/TemplateBloat.htm

IOW, I'm not sure you can fully automate this, but you can get a bit beyond
cut/paste.

 

[David Sisson]

From Word, F11, File -> Print, Select 'Current Project'. Let'er rip!

 

[Karl E. Peterson]

From Word, F11, File -> Print, Select 'Current Project'. Let'er rip!

Huh. Just goes to show ya... I guess I haven't printed source code, or at least
entire projects, since the days of DOS. <g>

 

[David Sisson]

- Show quoted text -

Oops! That's Alt-F11. (to get to the VBA editor, in other words.)

Karl... 'Forest for the trees' syndrome!

 

[Slowconn]

Karl, that's very interesting. The code-cleaner macros are protected, but
there must be a programmatic way of exporting all macros in a project.
Thanks!

Is there any way (i.e., a macro or builtin) to print all the macros in a VB
project? Or to copy them to a Word file? (Particularly where there are many
modules and it’s a bit of a pain to copy and paste all the modules into Word
manually.) I’m using Word 2003 at the office, but Word 97 at home.

Maybe use a code cleaner[1] to export all the modules, then load'em up and print'em
from somewhere?

[1] http://word.mvps.org/FAQs/MacrosVBA/TemplateBloat.htm

IOW, I'm not sure you can fully automate this, but you can get a bit beyond
cut/paste.

 

[Slowconn]

David, amazing! I never realized that was available. Thanks!

 

[Karl E. Peterson]

Karl... 'Forest for the trees' syndrome!

Zactly... The obvious is just so, uh, obtuse at times, eh? <g>

 

[Karl E. Peterson]

Karl, that's very interesting. The code-cleaner macros are protected, but
there must be a programmatic way of exporting all macros in a project.

Indeed there is. The code-cleaner does just that! <g>