View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer Bob Kilmer is offline
external usenet poster
 
Posts: 280
Default Opening and saving a template ?

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.)

--
Bob Kilmer


"David" wrote in message
...
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.