ok, thanks for the explanation.

regarding whether they have the files, they do. they're the ones that gave them
to me to automate. doesn't work on another pc i have here, either. just won't
open the file.

i am not going to worry about it, i scrapped the template idea and moved on.

--


Gary


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
A template file is normally used to create new .xls files. When you choose
File | New and then On My Computer you go to the place where template files
are stored. When you choose a template it is given the main part of the
template's file name, a number beginning with 1 and file type of .xls,

So when the other person goes through that process, they are choosing
filename.xlt as the template and it is being named as filename1.xls

Back at your place, you probably still have file Type selected as .xlt and
when you open it, Excel thinks you still want to edit the template rather
than creating a new file from it.

As for that other person not being able to get it to open workbooks that
code in that workbook refers to, that could be caused by several things: do
they even have those workbooks available to be opened and are those workbooks
in the same path that was specified in the code?

"Gary Keramidas" wrote:

i have a workbook i saved as a template, filename.xlt
1. i sent it to a client and when they opened it, it showed filename1 in the
title bar. when i open it, it's still called filename.xlt

2. when they tried to run code i have that opens another workbook, it
wouldn't
open it.

anyone know why these things happened?
--


Gary