Printing macro code

Posted by Ian Bartlett on August 07, 2001 12:57 AM

I have a spreadsheet with around 130 macros in it, and I'd like to document my work. The macros are spread across several modules. Is there an easy way of printing out all macros in a workbook, maybe via Word so that I can control the formatting (it'll probably need to print landscape), sort them, produce an index of the macro names and save a copy of the resulting document?

Many thanks,

Ian

Posted by Ivan F Moala on August 07, 2001 2:17 AM

Try Export your modules, then open them up in word
The modules are in ASCII format so there should be
no problem opening them up.
Just right click the modules and select Export.

You could automate this.......will look into it
just gave me an idea......

Ivan

Posted by Ian Bartlett on August 07, 2001 11:40 AM

Ivan

Thanks - that certainly gets the text into Word, and I can format it from there on with Word macros. Any idea how to automate the export of the module.bas files? (I tried the macro recorder, which rewarded me with a blank macro...)

Regards,

Ian