Stripping a VB Macro

Discussion:

(too old to reply)

Steve Schroeder

2007-10-22 20:19:48 UTC

We had an employee who created an embedded macro in our word documents,
using VB. Now that he is gone my boss wants me to go in and remove all
traces of the macro.

I have gone into VB withen the document by doing alt+f11 and deleted the
project for the macro. Not sure if this gets rid of everything or not.

Can anyone tell me either how to do this a program that goes in and strips
everything out? I would really hate to recreate 400 documents lol

Thanks for the help

Klaus Linke

2007-10-26 15:40:10 UTC

Permalink

Post by Steve Schroeder
We had an employee who created an embedded macro in our word documents,
using VB. Now that he is gone my boss wants me to go in and remove all
traces of the macro.
I have gone into VB withen the document by doing alt+f11 and deleted the
project for the macro. Not sure if this gets rid of everything or not.
Can anyone tell me either how to do this a program that goes in and strips
everything out? I would really hate to recreate 400 documents lol
Thanks for the help

Hi Steve,

The docs are all in one folder? You could use the Batch Conversion Wizard to
convert them to RTF.
That'll get rid of the macro, and is highly unlikely to loose you anything
else (formatting...).

If you don't like having the docs in RTF format, you could convert the whole
folder back to *.doc then.

To get at the batch conversion wizard, follow the same steps as if you
wanted to create a new doc, and look in the dialog that lists the templates
on your computer under "Other documents".

Regards,
Klaus

Steve

2007-10-30 16:03:33 UTC

Permalink

Thanks for idea i will look in it.