Closing Word without the prompt to save changes

[mleviton]

I am using an Access db to populate a word document, print it, and
close it. When it runs, the user should not be promted to save changes
when the document closes. The code includes
objWord.Documents("timesheet.doc").Close SaveChanges = False and
works on the win2000 server but the win2003 server prompts the user to
save changes. The following line works on our 2000 server (Office 10),
works on XP pro (Office 11) but not on 2003 server (Office 11).

objWord.Documents("timesheet.doc").Close SaveChanges =
False

We have also tried the following on our 2003 server without any luck:

Application.Quit(Word.WdSaveOptions.wdDoNotSaveChanges)

Private Sub Document_Close()
Me.Saved = True
End Sub

Application.DisplayAlerts = wdAlertsNone

objWord.Documents.Active.Close wdDoNotSaveChanges

All of these still prompt to save changes.
Thanks in advance for the help - PPT

 

[Dave Lett]

You can try

Application.DisplayAlerts = wdAlertsNone

before the close event.
After the close event, you can reset the .DisplayAlerts property again.

HTH,
Dave

 

[mleviton]

Thanks Dave, but I still get prompted to save changes when I use
Application.DisplayAlerts = wdAlertsNone
Could there be something else overriding this code?

-PaPaTwin

 

[Dave Lett]

Hi,
You can also try using

ActiveDocument.Saved = True

HTH,
Dave

 

[mleviton]

Awesome! That line worked. Thanks Dave.