Remove Macros

[Jim]

I have written a macro in Excel which copies data from a work sheet then
automatically opens a specific file in word.

In the word file I have an AutoOpen macro which pastes the data then brings
up the save as dialog box.

I only want the macro in the word document to run once so once it has been
saved i want to delete the macros of permanently disable them. Is this
possible or is there a better way of pasting the excel data into a new sheet
say using a template?

 

[Doug Robbins - Word MVP]

You should save your Word document as a template and rename the autoopen
macro to autonew.

Then, instead of having your macro open a Word document, have it create a
new document from a template.

--
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

 

[Jim]

Many thanks for your help, worked a treat

You should save your Word document as a template and rename the autoopen
macro to autonew.

Then, instead of having your macro open a Word document, have it create a
new document from a template.

--
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