How to Open a Copy of a Template in MS Excel 7.0, 97

This article was previously published under Q133137
This article has been archived. It is offered "as is" and will no longer be updated.
Summary
Microsoft Excel provides several ways for you to create a copy of atemplate. However, if you use the Open command on the File menu to open atemplate, the template opens in edit mode. In earlier versions of MicrosoftExcel, when you click Open on the File menu to open a template, a copy ofthe template opens instead.

This article discuss ways you can create a copy of a template.
More information
Method 1: Use the Templates folder

  1. Save the workbook template in the Templates folder or in a folder located inside the Templates folder.
  2. When you save the file in the Templates folder, you can create a copy of the template by clicking New on the file menu in Microsoft Excel.


The template will be located on the General tab.

NOTE: If you save the template in a folder that is located inside the Templates folder, you can still create a copy of the template by clicking New on the File menu in Microsoft Excel. However, the template will be located on the tab that has the same name as the folder in which that template is stored.

Method 2: Use the Xlstart folder

  1. Save the Microsoft Excel workbook template in the Xlstart folder.
  2. When you save the file in the Xlstart folder, you can create a copy of the template by clicking New on the File menu in Microsoft Excel. A template stored in the Xlstart folder always appears on the General tab.
Method 3: Use the alternate startup folder

  1. Save the Microsoft Excel workbook template in the alternate startup folder.

    The alternate startup folder is a folder of your choice. You can specify the alternate startup folder for Microsoft Excel by clicking Options on the Tools menu. On the General tab of the Options dialog box you can specify a folder that behaves just like the Xlstart folder.
  2. After you save the file in the alternate startup folder, you can create a copy of the template by clicking New on the File menu in Microsoft Excel.

    A template stored in the alternate startup folder always appears on the General tab.
Method 4: Use a Macro
If you store a template in a folder other than those listed in methods 1 through 3, you must use a macro to open a copy of the template. To open a copy of a template, use the following line in a Visual Basic macro:
             Workbooks.Add Template:= <template path and filename>					

Example

This example assumes you saved a template workbook in the c:\Xlfiles folder and called the template Template.xlt.
         Sub Open_Template()             Workbooks.Add Template:= "C:\Xlfiles\Template.xlt"          End Sub				
References
For additional information, please see the following article in theMicrosoft Knowledge Base:
129279 XL7: Open Command Without SHIFT Opens Template for Editing
8.00 97 XL
Properties

Article ID: 133137 - Last Review: 10/26/2013 01:08:00 - Revision: 2.0

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • kbnosurvey kbarchive kbdtacode kbhowto kbprogramming kbualink97 KB133137
Feedback