Hello, I have inherited a number of DOT files that I need to work through and establish what they do (They contain lots of VBA/Macros). Is there a tool out there to strip all Macros out into say a notepad file for easy review ? So far I can see that I need to access the files as a macro and then also access the VB in the Visual Basic Editor. Then the forms, are again in another place. As I need to decipher what the macro's do, this makes life hard. I really just want to run a tool against the template and print a report with all the code in an easy to read manor. Any ideas ? Thanks in advance ! -- Regards, Michael Jenkin MCP MVP SBS Australia www.mickyj.com
Take a look at the VBA Code Cleaner available from http://word.mvps.org/Downloads/index.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael Jenkin [SBS-MVP]" wrote in message news:eofa5sU%23FHA.740@TK2MSFTNGP12.phx.gbl... > Hello, > > I have inherited a number of DOT files that I need to work through and > establish what they do (They contain lots of VBA/Macros). > > Is there a tool out there to strip all Macros out into say a notepad > file for easy review ? > > So far I can see that I need to access the files as a macro and then > also access the VB in the Visual Basic Editor. Then the forms, are again > in another place. As I need to decipher what the macro's do, this makes > life hard. > > I really just want to run a tool against the template and print a report > with all the code in an easy to read manor. > > Any ideas ? > > Thanks in advance ! > > -- > Regards, > > Michael Jenkin > MCP MVP SBS > Australia > > www.mickyj.com
Thankyou for your help. Whilst it did not get 100% of what I was after, it got 99% :) Thanks agian Doug Robbins - Word MVP wrote: > Take a look at the VBA Code Cleaner available from > http://word.mvps.org/Downloads/index.htm > > -- Regards, Michael Jenkin MCP MVP SBS Australia www.mickyj.com
