Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Using a Standard Format in a Suggested File Name.

Using a Standard Format in a Suggested File Name

by Allen Wyatt
(last updated January 27, 2017)

2

Richard asked if there was a way to modify the Word-generated file name that is suggested when you choose Save As or, in the case of a brand new document, click the Save tool. He wants to suggest a standard file named that contains the date as the prefix for that name.

There are actually two different concepts at work here, depending on whether you are working on a new document or an existing document. If you are working with an existing document, then the file name suggested when you click on Save As is actually the document's current file name.

If you are working with a new document, then there is no functional difference between choosing Save or Save As; they both pull up the Save As dialog box. In this case, the suggested file name is based on the setting of the Title field in the Properties dialog box. (Choose File | Properties.) If there is nothing in the Title field, then the suggested title is based on the first line of text in the file, up to the first punctuation mark.

Given the way that Word comes up with the suggested names, there are a couple things that can be done to utilize a standard. The first is to modify the template used for the documents, so that the Title field is set in it. For instance, follow these steps:

  1. Load Normal.dot or the template you want to modify.
  2. Choose File | Properties to display the Properties dialog box for the file.
  3. Make sure the Summary tab is displayed. (See Figure 1.)
  4. Figure 1. The Summary tab of the Properties dialog box.

  5. In the Title field, enter the pattern you want used for file names. For instance, you might enter "yyyymmdd - Title".
  6. Click OK.
  7. Save and close the template.

Now, whenever you open a document based on that template, the Title field will already be set. When someone first saves the document, the title you entered in step 4 is suggested. This will spur the user to replace "yyyymmdd" with the proper date, and replace "Title" with the real title.

If you want something more automatic—perhaps where the date is automatically filled in—then you need to rely on a macro. You essentially need to create a macro that replaces the Save and Save As commands, and fills in the suggested file name as you want it done. Information on how to intercept various commands (such as Save and Save As) can be found at the Word MVP Web site:

http://www.wordmvp.com/faqs/macrosvba/InterceptSavePrint.htm

In the macro you create, you can set the desired name before showing the File Save As dialog box. For instance, this snippet of code will handle the trick:

Dim sDefaultFileName as String
sDefaultFileName  =  "MyPaper"
With Application.Dialogs(wdDialogFileSaveAs)
    .Name = sDefaultFileName
    .Format = 0     '2 = Plain Text, 0 = Word Doc
    If .Show = 0 Then   'User did not save
    End If
End With

Remember that this code needs to be placed within a larger macro that you develop as a replacement for the Save As command. The .Show method is what actually displays the dialog box.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3531) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Using a Standard Format in a Suggested File Name.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Generating Double-Digit Random Numbers

Normally you use the RAND and RANDBETWEEN functions to generate random numbers. What if you want to generate random numbers ...

Discover More

Introducing the Organizer

The Organizer is a great tool for, well, organizing the information stored in your templates. This tip introduces the ...

Discover More

Changing the Format of Existing Dates

There are a myriad of ways in which a date can be formatted—day first, month first, number of digits in the year, etc. ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

MORE WORDTIPS (MENU)

Avoiding the Update Links Message

Word allows you to establish links from one document to another. When you open a document containing these links, you may be ...

Discover More

Files Open in Word 2003, but not Word 2000

If you have some documents that open in Word 2003, but not in Word 2000, it may mean that you are running into some strange ...

Discover More

Opening Word 2007 Files in Older Versions

Word 2007 uses a different file format than was used in previous versions of Word. This can cause some problems in opening ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is three minus 1?

2014-03-06 05:17:33

Henk

You write: For instance, you might enter "yyyymmdd - Title".

This doesn't work, as Word breaks of at the minus sign.

So in this case the user will see 'yyyymmdd' as suggested filename. In stead of ' yyyymmdd - Title'.

Is there a way to fix this and show the minus sign?


2013-11-11 10:34:25

Don

Allen....

Hate to harp but the one thing that caught my eye in Richard's request was prefixing with the date. Assuming current date, I would make the following change

.Name = Format(Now(), "yyyy-mm-dd") & " " & sDefaultFileName


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing