Opening and saving a template ?

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am getting strange behaviour in Win 2000. When I double
click on the template it opens it as an XLS (renaming it)
and when I right-click and choose open, it opens it as
XLT. Is this normal?

Also, when I click save, sometimes it saves it as a
template and sometimes as an XLS.
Where does a macro go when I save it? Sometimes it just
saves and does not tell me where it put it and sometimes
it asks me for a folder and type. Also I noticed it
defaults to some Microsoft Template library which is NOT
where I want it.

I'm very confused about this strange behaviour with
templates.
 
If you look at the microsoft excel template type in Folder Options, you will
see the default action is

is NEW and the definition if you edit that is [new("%1")]

This says to use the template as the basis for a new xls file.

If you select the file from Excel file open dialog and open it, then you are
opening the template for editing.
 
David said:
I am getting strange behaviour in Win 2000. When I double
click on the template it opens it as an XLS (renaming it)
and when I right-click and choose open, it opens it as
XLT. Is this normal?
Click to expand...

Yes, this is normal, and what should happen.
Also, when I click save, sometimes it saves it as a
template and sometimes as an XLS.
Click to expand...

Surely, that depends upomn whether you have 'New'ed based upomn the
template, or opened the template?
Where does a macro go when I save it? Sometimes it just
saves and does not tell me where it put it and sometimes
it asks me for a folder and type.
Click to expand...

A macro is stoired in the workbook that you spevcify, and is saved with it
when you save the workbook.What do you mean by it asks youy for a folder
and type, is this when you save it?
Also I noticed it
defaults to some Microsoft Template library which is NOT
where I want it.
Click to expand...
The default directory for templates is the template directory, and Excel
will point at that directory if you specify a file type as a template. If
you don't want it there, such as Book.xlt which should be in XLStart, you
have to re-direct it./

Have a look at Tom Ogilvy's response to one of your earlier questions, lots
of possible suggestions for you to look at within that response which may
just as well apply here.

HTH

Bob
 
If I right click on an Excel template, the top two options are New and Open,
in that order. New is in bold, indicating, as is the Windows standard, that
New is the default action -- that is, New is the action that occurs if the
object is "executed" -- double-clicked or selected then Enter pressed. New,
as has been said, opens a new workbook based upon the template, NOT the
template itself. On the other hand, Open opens the template itself. Use New
when you want a new workbook based on the template. Use Open when you want
to modify the template itself. (This usage of New and Open is consistent
within Excel also.)
 
If I right click on an Excel template,

to be clear, I should have added "in Windows Explorer"
 
Thanks a lot, that makes it really clear!
-----Original Message-----
If I right click on an Excel template, the top two options are New and Open,
in that order. New is in bold, indicating, as is the Windows standard, that
New is the default action -- that is, New is the action that occurs if the
object is "executed" -- double-clicked or selected then Enter pressed. New,
as has been said, opens a new workbook based upon the template, NOT the
template itself. On the other hand, Open opens the template itself. Use New
when you want a new workbook based on the template. Use Open when you want
to modify the template itself. (This usage of New and
Click to expand...
Open is consistent within Excel also.)
 
Back
Top