MORE INFORMATION
CREATING A TEMPLATE
To create a sample template, follow these steps:
- Start Microsoft Excel 98 and create a new workbook.
- Type the following in cell A1 in the new workbook:
A1: This is an Excel sample template.
- On the File menu, click Save As.
- In the Save Files as Type box, click Template.
- In the Save as box, type My Excel Template.
- Switch to the <hard disk>:Microsoft Office 98:Templates folder, where
<hard disk> is the name of your hard disk.
- Click Save.
- On the File menu, click Close.
You have created a sample Excel template. Microsoft Excel 98 provides
several different ways to create a new workbook that is based on a
template. The following are different ways to create a new workbook that is
based on a template in Microsoft Excel 98.
CREATING A NEW WORKBOOK THAT IS BASED ON A TEMPLATE
Method 1: Use the Templates That Are in the Templates Folder
In the previous example, you save a template called My Excel Template in
the <hard disk>:Microsoft Office 98:Templates folder. To create a new
workbook that is based on this template or that is based on other templates
that are stored in the Templates folder, click New on the File menu, select
the template you want to use, and click OK.
Note that you can find My Excel Template on the General tab in the New
dialog box. Any template that is stored in the <hard disk>:Microsoft Office
98:Templates folder appears on the General tab. You can also create your
own tabs on the new dialog box. To do this, create subfolders in the <hard
disk>:Microsoft Office 98:Templates folder, and then place your templates
in the folder. To create a sample tab on the New dialog box, follow these
steps:
- Start Microsoft Excel 98.
- In a new workbook, type the following:
- On the File menu, click Save As. Switch to the <hard disk>:Microsoft
Office 98:Templates folder.
- Click the New button and create a new folder.
- Type MyTab in the name of new folder
box, and then click Create.
- In the Save As box, type Test.
- In the Save File As Type box, click Template. Click Save.
- On the File menu, click Close.
- On the File menu, click New.
A new tab called MyTab is in the New dialog box.
NOTE: If there are no Microsoft Excel templates in the folder that you have
created, you do not see a tab called MyTab in the New dialog box.
Method 2: Use the Templates That Are in the Excel Startup Folder
When you save a template in the Excel Startup folder, you can create a new
workbook that is based on that template by clicking New on the File menu in
Microsoft Excel. A template that is stored in the Excel Startup folder
always appears on the General tab.
The Excel Startup folder is in the following location on the hard disk:
<hard disk>:Microsoft Office 98:Office:Startup:Excel
Method 3: Use the Alternate Startup Folder
The alternate startup folder works the same way the Excel Startup folder
works. However, the alternate startup folder is a folder of your choice. To
specify the alternate startup folder location for Microsoft Excel, follow
these steps:
- On the Tools menu, click Preferences.
- Click the General tab in the Preferences dialog box.
- In the Alternate Startup File Location box, specify a path to a folder
that you want to use.
After you save the file in the alternate startup folder, you can create a
new workbook that is based on 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.
For additional information about the alternate startup folder, please see
the following article in the Microsoft Knowledge Base:
183757 XL98: How to Change the Alternate Startup Folder
Method 4: Use a Macro
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
If you store a template in a folder other than the folders that are listed
in the first three methods, you must use a macro to create a new workbook
that is based on a template. To open the template, use the following line
in a Visual Basic macro:
Workbooks.Add Template:= <template path and file name>
Example:
This example assumes you have saved a template workbook in the <hard
disk>:Xlfiles folder and have called the template
Template.
Sub Open_Template()
Workbooks.Add Template:= "<hard disk>:Xlfiles:Template"
End Sub
Note that <hard disk> is the name of the hard disk on your computer.
EDITING AN EXISTING TEMPLATE
To edit an existing template in Microsoft Excel 98, use the following
steps:
- On the File menu, click Open.
- Open the <hard disk>:Microsoft Office 98:Templates folder.
- Click My Excel Template. Hold down the SHIFT key and click OK.
- Continue to hold down the SHIFT key until the template is open.
- Type the following into the worksheet:
- On the File menu, click Save.
- On the File menu, click Close.
The template has been modified and saved. To use the updated template,
click New on the File menu and click My Excel Template. A new workbook that
is based on the template is created.
REFERENCES
For more information about using templates, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
templates, creating and editing
and then click Show Topics. Select the "Customize the defaults for a
workbook or worksheets by using a template" topic, and click Go To. If you
are unable to find the information you need, ask the Office Assistant.