Suppress Word "Would you like to save this doc" message

[DrSmyth]

Hi,

I've got a word form with a few bits of vba on it that people are accessing through an intranet. However, when people back up out of the page it always asks them if they would like to save the document, is there any way of suppressing this message?

Andy

 

[Sheffield]

DrSmyth,

To avoid those dialog boxes in Excel, I use the following bit of code. Presumably, aside from the 'SaveAs' method arguments, something similar should work in Word as well.

Application.DisplayAlerts = False
ThisWorkbook.SaveAs "testfile.xls", xlWorkbookNormal
Application.DisplayAlerts = True

Good Luck

 

[Nikita6003]

Hiya,

just to add to that: instead of TRUE/FALSE you can use the following 3 constants in Word:
[ul]
[li]wdAlertsAll[/li]
[li]wdAlertsNone[/li]
[li]wdAlertsMessageBox[/li]
[/ul]

HTH


Cheers
Nikki
Look, mommy, I'm flying!

 

[DrSmyth]

Cheers Gents, works like a dream....