Dave

But George wrote that his file is named test1.xlt.

This from George's original post..............

For example, if the name of the XLT file is
Test.xlt, the active workbook's name changes to Test1.xlt,
having a "1" appending to the end of the name.

Gord

If it were just test.xlt or test1, I think I'd understand. But George wrote
test1.xlt.

If it was a typo in George's post, then your explanation makes good sense to
me. But if it weren't a typo, I think there's something still missing.

(I've never seen the behavior that George described, though.)

"Ken Laws [MS]" wrote:

Hi George,

My name is Ken. Thank you for using the Microsoft Newsgroups.

Based upon my understanding of your question, you would like to know why
you are seeing different resulting file names within Microsoft Excel based
upon the method that you use to open an XLT file.

Using the following three methods that you have provided to open the file,
I will attempt to explain the behavior that you are seeing.

1. Opening the XLT file using File -- Open within Microsoft Excel

Using this method you are instructing Microsoft Excel to simply open the
XLT file which results in the file name being the exact name of the file
that you opened.

2. Double clicking to open the XLT file.

Using this method you are relying on the Windows File Association to
determine which application to use to open the file and also the default
action to take when opening the file. For an XLT file there are by default
three actions that could occur:

A. New - creates a new file based on the XLT file.
B. Open - opens the XLT file.
C. Print - sends the file to the printer.

By default the default action for an XLT file is New. This means that if
you double click on the XLT or right mouse click on the XLT and choose Open
With, the action will be to create a new file based on the template and the
name of the file will be the original template name with a number appended
such as 1,2,3, etc.

3. Using SendTo to open the XLT file with Microsoft Excel.

This method performs a shell execute to open Microsoft Excel and passes the
file name to open, which would in essence generate the same behavior as
opening Microsoft Excel and then opening the XLT file, thus resulting in
the file name being the name of the XLT file.

I hope this helps!

If you have any questions please let me know via the posting.

Regards,

Ken Laws
Microsoft Support


This posting is provided "AS IS" with no warranties, and confers no rights.