View Single Post
  #4   Report Post  
RagDyer
 
Posts: n/a
Default

See if this works for you.

Do all this from *that* single machine.

Open Windows Explorer, and create a new folder on the machines C:\ drive.
Say you name it
User1

Navigate to your templates folder on the server and copy the template in
question to this *new, empty* User1 folder (should be a .xlt file as you
said).

Close Explorer and open XL.
<Tools <Options <General tab,
In the Alternate StartUp File Location box, enter:
c:\user1\
Then <OK out , and close XL.

Re-open XL, and you should see the *normal* book1 open.
That means, that since that Alternate StartUp file is populated with only a
..xlt file, nothing out of the ordinary occurs.

Now, from XL, navigate to the "user1" file and open that .xlt template file,
and do a "save as", and save as a XL workbook (.xls) to this same "user1"
file.
Make sure the name is spelled correctly, removing any suffixes or
extensions.

Now close XL once more, and then re-open.

You should now see that this template will become the default start-up WB.

The main rule is:
*Everything* in the Alternate StartUp File Location will open when XL opens,
*EXCEPT* .xlt template files.

The user will now use the template and when finished, will do a "SaveAs" to
rename it, and the default folder it will be saved in should be the file
that you designated in the "Default File Location" window.

You can keep the .xlt template file in that "user1" folder, just in case you
need to copy and transform it to a .xls file again.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"James Kendall" wrote in message
...
Please see the answers below the questions. Thanks.
--
Thank you for your time.
Windows NT
Office 97


"Ragdyer" wrote:

Some questions:

Is the template a .xls file or a .xtl file?

The file is an .xlt file.
Is the file (folder) that the template is stored in on the network

drive?
The file is under a folder on the network drive.
Is this file populated with other XL WBs (files)?

The Network file folder is populated with several xl* files that are used
regularly.
If yes, are these other XL WBs (files) .xlt or .xls files?

Both.
Would you want this template to open automatically in XL on *all* the
machines on the network, or just certain ones?

No. I only need this on one persons signon or just his workstation.

--
Regards,

RD


--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-

"James Kendall" wrote in

message
...
I have been asked if you can start up a template on automatically

opening
the
Excel program when someone starts the computer. I can get Excel to

open
but
I can not get the template to open automatically. How can I do this?

I
have
tried to put the template in the XLStart folder under the program

file\office
on the local drive and even in the startup folder. Neither worked and

one
opened then closed Excel. One more thing worth mentioning. This

template
is
on a network drive. I tried placing the template file on the local

and
network drive but neither opened it when put into the startup areas.

What
am
I doing wrong? --Frustrated at this point--
--
Thank you for your time.
Windows NT
Office 97