Thread: XLT Templete
View Single Post
  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

When you open a template you shouldn't open the template file itself
directly, do filenew and you get a box with templates, if you open it from
there it will open a copy

Regards,

Peo Sjoblom

"Datasort" wrote in message
...
Doco ... thanks for the info ... I understand the process. But that is

now
what is happening.

When I open the file names pform.xlt I expect the file to say at the top
"pform1" but instead it says pform.xlt. Thus Excel is not recognizing the
file as a template.

Below is the name of the file copied from the VB immediate window:

?activeworkbook.Name
PFORM.xlt


Any more thoughts?

Stewart Rogers

"doco" wrote:

What do you mean by "save over"? After creation and saving a template

as
*.xlt and re-opening it, then saving the file again, the default process

is
for the CommonDialog to appear and prompt to save as *.xls unless you

make a
file type selection different from that and at that time. It will not
overwrite your original *.xlt file.

HTH
doco




"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