I built a template in Excel 2000. I would like to force this to open as a
workbook, but every time it opens as a template (if you click save, the
changes are made to the .xlt file).

How do I make it open into a new workbook instead of the template?

I've currently written VBA code to force the user to save the template as a
workbook when the template's opened, but that copies to the new workbook as
well, forcing the user to save the new workbook with a new name.
--
Adios,
Clay Harryman

Sounds like you are opening the template directly.

Where is it located and how do you open it?

If it has been saved as a template(*.xlt) then you should be able to click on
FileNew...On My Computerselect the template and open.

Should open as templatename1.

Do your work then FileSave. You will be prompted for a name.

It will save as *.xls


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 08:30:03 -0700, Clayman
wrote:

I built a template in Excel 2000. I would like to force this to open as a
workbook, but every time it opens as a template (if you click save, the
changes are made to the .xlt file).

How do I make it open into a new workbook instead of the template?

I've currently written VBA code to force the user to save the template as a
workbook when the template's opened, but that copies to the new workbook as
well, forcing the user to save the new workbook with a new name.

Thanks, Gord.

I've stored the templates into a network folder that various people can open.

I know I can either copy the templates to the individual folders, but these
templates are subject to occasional revision (changes in pay rates,
transfers, etc). The next idea would be to point the users' template folders
to the network folders that contain these templates. I'll have to get with a
Network Admin to edit their login scripts

<begin rant
Maybe it would be better just to make a master spreadsheet than a template.
I'm trying to sell these folks on using Access instead of Excel, but they
don't want to pay the money...
<end rant
--
Adios,
Clay Harryman


"Gord Dibben" wrote:

Sounds like you are opening the template directly.

Where is it located and how do you open it?

If it has been saved as a template(*.xlt) then you should be able to click on
FileNew...On My Computerselect the template and open.

Should open as templatename1.

Do your work then FileSave. You will be prompted for a name.

It will save as *.xls


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 08:30:03 -0700, Clayman
wrote:

I built a template in Excel 2000. I would like to force this to open as a
workbook, but every time it opens as a template (if you click save, the
changes are made to the .xlt file).

How do I make it open into a new workbook instead of the template?

I've currently written VBA code to force the user to save the template as a
workbook when the template's opened, but that copies to the new workbook as
well, forcing the user to save the new workbook with a new name.

OK - I made a shortcut to the template in the templates folder. This way, we
can update the templates as needed and still use templates as they were
originally intended.

Thanks, Gord! I wouldn't have gotten to this point without your push!
--
Adios,
Clay Harryman


"Gord Dibben" wrote:

Sounds like you are opening the template directly.

Where is it located and how do you open it?

If it has been saved as a template(*.xlt) then you should be able to click on
FileNew...On My Computerselect the template and open.

Should open as templatename1.

Do your work then FileSave. You will be prompted for a name.

It will save as *.xls


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 08:30:03 -0700, Clayman
wrote:

I built a template in Excel 2000. I would like to force this to open as a
workbook, but every time it opens as a template (if you click save, the
changes are made to the .xlt file).

How do I make it open into a new workbook instead of the template?

I've currently written VBA code to force the user to save the template as a
workbook when the template's opened, but that copies to the new workbook as
well, forcing the user to save the new workbook with a new name.

Thanks for the feedback.

Gord

On Fri, 6 Jul 2007 10:02:05 -0700, Clayman
wrote:

OK - I made a shortcut to the template in the templates folder. This way, we
can update the templates as needed and still use templates as they were
originally intended.

Thanks, Gord! I wouldn't have gotten to this point without your push!