Discussion:
How to Export All Macros from Office 2000 .Dot file
(too old to reply)
Michael Jenkin [SBS-MVP]
2005-12-05 03:53:08 UTC
Permalink
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
Doug Robbins - Word MVP
2005-12-05 05:26:45 UTC
Permalink
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
Post by Michael Jenkin [SBS-MVP]
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
Michael Jenkin [SBS-MVP]
2005-12-06 06:46:33 UTC
Permalink
Thankyou for your help. Whilst it did not get 100% of what I was after,
it got 99% :)

Thanks agian
Post by Doug Robbins - Word MVP
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
Loading...