#1   Report Post  
RagDyer
 
Posts: n/a
Default

You can put .xls files in the template folder, and they'll be accessable in
the <File <New folder also. So, no need to make .xlt extensions if you
wish to open copies from the <Files <New folder.

So maybe we're at a semantics discussion here.

You probably mentioned indirectly the main topic.

How do you open, or, how do you *wish* to open copies of the template for
use.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Dave Peterson" wrote in message
...
I understand that technically the fileformat is marked Template vs Workbook,
but
if I save a workbook as .xls (normal workbook), and then rename it to .xlt
(not
saving it that way), it sure behaves like a template to me.

If I put it in my templates folder, I can use file|new ok.

If I double click on it in windows explorer, I get a workbook based on that
"workbook/template".

I don't see a significant difference between these animals.



RagDyer wrote:

It really depends on your definition of a template.

The context of this thread is pertaining to an Excel Template, where a
*copy* is *automatically* opened, and the original is *not*.

If you wish, you can call any .xls or .xlt file a template, where you open
it, add data, and then "Save As" to a new name, preserving the original in
that "round about" way.

That is *not* an Excel designated template.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"GregR" wrote in message
...
If the file is saved as a template with XLT extention, it is a template no
matter where it is saved.

Greg
"Datasort" wrote in message
...
RD,

Thanks for your reply. I am saving in a c drive path that is not part

of
the MS programs path. Example .. C:\temp

I am also selecting the Templete as the "save file type"

So it looks like the question is ... does a .xlt mean it is a templete

or
not ... no matter where the file is saved?

Regards,

Stewart

"RagDyer" wrote:

I believe that Excel 5.0 was the last version of XL, where the .xlt
extension *automatically* created a template.

From then on, at least from XL97 on (not sure of 95), *WHERE* the WB

is
saved determines whether or not it's a *true* XL template.

When you went to save your WB, if you expanded the "files of type"

box,
and
chose "Template (.xlt)", XL automatically directed the WB to be saved

in
the
Windows Template folder, AND, incidentally appended the .xlt

extension.
I say incidentally because, even an .xls WB, saved in the Template

folder,
becomes a "true" XL template, where a *copy* is able to be accessed in

the
<File <New folder, preserving the original from modification.

There are, of course, many other procedures for creating and saving

"true"
XL templates, besides just placing them in the Templates folder.

SO ... the pertinent question is ... WHERE is your WB saved, and HOW

did
you
save it?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Datasort" wrote in message
...
I have saved an xl file as .xlt extention. When I open up the file it

is
not
in templete mode. I am about to save over the templete.

Can you tell me what I am missing

Regards,

Stewart Rogers



--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for Manpower Templete Help John Smith Excel Discussion (Misc queries) 0 December 3rd 04 01:33 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"