Normal.dot problem when closing word after VBA opens it

[1DMF]

Hi,

I am working on a mail merge document, which part of the specification is the user wishes to have the final document open to edit it before printing.

I use the following code...

    If sView = "Yes" Then
        Set WordApp = CreateObject("Word.Application")
        WordApp.Documents.Open sWord
        WordApp.Visible = True
        If vbNo = MsgBox("Are you happy with the document?", vbYesNo) Then
            sDoUpd = "No"
            Set WordApp = Nothing
            KillFile sWord
            Exit Sub
        End If
    End If

    Set WordApp = Nothing
    SetAttr sWord, vbReadOnly
    Exit Sub

however when the open word doc is closed I keep getting the following error in word...

How do resolve this issue?

Thanks,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

Found the answer...

        WordApp.NormalTemplate.Saved = True

placed after making the document visible.

found fix via

http://support.microsoft.com/kb/285885

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts