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:

    
Set AppWord = New Word.Application
    AppWord.Visible = True
    Set DocWord = AppWord.Documents.Add
    For Each ws In ActiveWorkbook.Worksheets
      If ws.Range("A11").Value = "INCOME STATEMENT" Then
        ws.Activate
        ActiveSheet.Range("A1:E132").Copy
        AppWord.Selection.PasteSpecial DataType:=wdPasteMetafilePicture,      Placement:=wdInLine
        Application.CutCopyMode = False
      End If
    Next ws
    Set AppWord = Nothing
    Set DocWord = Nothing
    ActiveWorkbook.Close False
Thanks for the help.