Delete VBA after use?

[pfrancis]

I have a word document that, when openned, brings up the insert file dialog box and then does some formatting (Find and Replace). After that it saves as a different file name. However, when you open the newly saved file, it runs the insert file and formating VBA again. Is there a way to remove the VBA from the newly saved file? Thanks for your help.

 

[PHV]

I have a word document that, when openned, ...
Why not make a template (.dot) and put the code in the Document_New event procedure instead of the Document_Open.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[pfrancis]

Sometimes it pays to think a little harder before you I post. I thought of that right after I read it again. Thank you for reminding me.