Thread: XLT Templete
View Single Post
  #3   Report Post  
Datasort
 
Posts: n/a
Default

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