You can try
Application.DisplayAlerts = wdAlertsNone
before the close event.
After the close event, you can reset the .DisplayAlerts property again.
HTH,
Dave
>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
[quoted text clipped - 21 lines]
> All of these still prompt to save changes.
> Thanks in advance for the help - PPT
mleviton@juno.com - 08 Aug 2006 14:40 GMT
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
> You can try
>
[quoted text clipped - 5 lines]
> HTH,
> Dave
Dave Lett - 08 Aug 2006 19:45 GMT
Hi,
You can also try using
ActiveDocument.Saved = True
HTH,
Dave
> Thanks Dave, but I still get prompted to save changes when I use
> Application.DisplayAlerts = wdAlertsNone
[quoted text clipped - 11 lines]
>> HTH,
>> Dave
mleviton@juno.com - 09 Aug 2006 17:23 GMT
Awesome! That line worked. Thanks Dave.
> Hi,
> You can also try using
[quoted text clipped - 3 lines]
> HTH,
> Dave