Welcome toWord.Tips.Net
Ask a Word Question
Make a Comment
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)
Editing a Toolbar Button Image
Making Macros Readily Available
Setting Prime Height Spacing in the Equation Editor
Automatically Updating Fields and Links
If you modify a Word document, and then close the document, you are asked if you want to save your changes. This is a good feature that helps ensure you don't mistakenly throw away some of your work.
When running a macro, however, you may not want to be bothered with a dialog box asking if you want to save your changes. If the macro modifies a document in some way, and you use the Close method, you are asked if you want to save your changes, just as you are if you manually close a document without saving.
The way to get around this is to use some of the parameters available with the close method. Consider the following:
ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges ActiveDocument.Close SaveChanges:=wdSaveChanges
Both lines of code close the active document. The difference between the lines is in the setting of the SaveChanges parameter. In the case of the first line, any changes will be discarded, while the second line results in the document being saved when it is closed. If you prefer to be asked every time, just use either of the following lines:
ActiveDocument.Close ActiveDocument.Close SaveChanges:=wdPromptToSaveChanges
Tip #1301 applies to Microsoft Word versions: 97 2000 2002 2003 2007
Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time!