Template Folder Location in Word 2007

by Allen Wyatt
(last updated June 24, 2014)

5

Don is having a problem with Word 2007. He is curious as to where the template folder is located in this version. He created a template and added it to what he thought was the template folder, but the template doesn't show up in the New Document templates.

The location for templates in Word 2007 is the same as it has been in other versions of Word. If you want to see what Word considers the location, then follow these steps:

  1. Click the Office button and then click Word Options. Word displays the Word Options dialog box.
  2. Click Advanced at the left side of the dialog box.
  3. Scroll through the list of options until you see the General section.
  4. Click the File Locations button. Word displays the File Locations dialog box. (See Figure 1.)
  5. Figure 1. The File Locations dialog box.

In the File Locations dialog box you can see the folders in which Word presumes you store both user templates and workgroup templates.

There is a difference in Word 2007 in how this location is handled when compared to earlier versions. The difference is that Word 2007 doesn't default to that folder when you are saving a file as a template. The reason for this change is security; the templates folder is trusted, meaning that any macro stored there is trusted by Word. To avoid the chance of placing an unwanted macro into a trusted location, Word 2007 doesn't store templates, by default, in the templates folder used by the program.

Fortunately, the template folder is now a default "place" in the hierarchy shown at the left side of the Save As dialog box. Click Templates in the hierarchy and the file will be saved in the proper templates location (the same one you saw in the File Locations dialog box). When you later want to create a new document based on the template, in the New Document dialog box you can select My Templates at the left side of the dialog box and see the templates that you've saved.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3391) applies to Microsoft Word 2007.

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

Quickly Changing Windows

Need to quickly move from one open Excel window to the other? The program provides a couple of handy shortcuts you can use, ...

Discover More

Cannot Open Word 2007 Documents Even When Saved in Earlier Version

Some people report that even if they save a Word 2007 document in a format suitable for earlier versions of Word, the ...

Discover More

Understanding Precedence

Formulas created in a macro have a specific order in which operations are performed. This is known as precedence, as ...

Discover More

Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!

MORE WORDTIPS (RIBBON)

Creating a Document Based on a Template

Double-click a Word template file in Windows, and Word should create a brand new document based on that template. If this ...

Discover More

Recovered Document becomes Default

Word has a feature called AutoRecover that helps you when Word or Windows crashes. If your Normal template gets messed up for ...

Discover More

Managing Corporate Templates

Templates are used to store styles and lots of other customizations that affect how you use Word. On a single-user machine, ...

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 6 - 0?

2017-06-06 12:51:34

ACody

Gary, it appears you have a different task in mind. If I understand correctly, you hide some data in each worksheet if it has a zero (0) in either of two columns, then want to print out approximately 30 worksheets on a single sheet with the data that is unhidden.

You are correct in that you can instruct your printer to do this but as you note the more data you add, the smaller the print gets. To get around this you can create a "print sheet" that consolidates the data on the other worksheets, then prints it out in a single print run (not necessarily on one sheet).

I'm in no way associated with Tips.net but in other forums we usually suggest that the first step to solve an Excel problem is to do a search of the net. Fortunately, Mr. Wyatt has published a solution to your issue. Here is the link:
https://excel.tips.net/T003243_Printing_Multiple_Worksheets_on_a_Single_Page.html

Study this macro and I think it may satisfy your need. You may need to modify the code a bit, but some of us that follow this forum can probably help with that.
Best, ACody


2017-06-05 10:45:43

Gary Lundblad

I have a similar request. I have a macro that hides rows with a zero in two different columns, and I have about 30 worksheets. I would like the whole print area to print out on one sheet unless it is going to make everything too small. So I'd like it to either print to one page high or two pages high, always by one column wide, based on the number of visible rows. Is there a way to do this that isn't too onerous?

Thank you!

Gary


2017-06-05 09:29:30

ACody

@CJ, thanks for your comment. Please note my comment at the end of the line of code -- 'change sheet and column as needed.


2017-06-04 22:22:26

CJ

@ACody, you're assuming the active sheet is called Sheet1 and that column A is the one used to determine the last data row.


2017-06-03 12:04:29

ACody

Nice macro. Can I suggest removing the second InputBox [sTemp = InputBox("Last row for page breaks:", sTitle)] because it forces the user to tab/scroll down to find the last row. Instead I would use the following code lines:

Dim sTemp2 As Long
sTemp2 = Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row 'change sheet and column as needed

This checks for the last row with data automatically, so no manual check is needed. Since sTemp was declared as a String (InputBoxes return string values), the use of the sTemp2 variable above will return a row number. So, I declared another variable - sTemp2 As Long. Also you would not need the line [lLastRow = Val(sTemp)] because it is converting a string to number, but you would need to keep lLastRow - sTemp2 because the lLastRow variable is used further down - in the loop. I think that would do it.



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
Share