Hi,

I've got a macro that formats certain excel tables and then automatically pastes them into a blank word document where they can easily be cut and pasted into a report.

However, if another word document is open when attempting to close out of the newly created word doc I get a series of prompts to save the normal.docm template.

Is there a way to change the VBA code to exclude the option to save the normal.docm template and allow the user to just close out of the file when finished.

Note: This macro will be used by many novice users and so changing the normal.docm save option in word options isn't an ideal solution.

Here's the code:

Please Login or Register  to view this content.
Thanks for the help.