Template questions

[Stuart]

I wish to distribute a template over a network, and the best method I've
seen described is to place the file on the
Server in a network folder, to which all the relevant users
have access.
I believe the next step is to run a batch file (which should
be located in each user's XLStart folder) to fetch a copy of the template to
their local drive, each time they start Excel.

Q1. What might that batch file look like?
Q2. Where does the template copy get stored?

Regards.

 

[Dave Peterson]

Why not just change the workgroup template location to point at that nice common
location?

Inside MSWord(!).
Tools|options|File Locations tab|
Workgroup templates

 

[Stuart]

Thanks.
Ok did that, then restarted Excel.
Clicked File>New and in the New Workbook pane
there was an entry for Templates>On my computer.
My file was listed there.

Was that as you intended........sorry, bit confused about this.
Regards.

 

[Dave Peterson]

That was part of what I intended. The remaining part is doing the same thing
for all your users.

 

[NickHK]

Stuart,
In case you did not noticed it, but Dave's advice says "inside Word". Excel does not have this setting, but reads from the Office setting.

NickHK

Thanks.
Ok did that, then restarted Excel.
Clicked File>New and in the New Workbook pane
there was an entry for Templates>On my computer.
My file was listed there.

Was that as you intended........sorry, bit confused about this.
Regards.

 

[Stuart]

Many thanks.
Did notice.

Regards.

Stuart,
In case you did not noticed it, but Dave's advice says "inside Word".
Excel does not have this setting, but reads from the Office setting.

NickHK

 

[Dave Peterson]

Another way to get to that setting (if your version of office supports it and
you have it installed) is through the Office shortcut bar. (xl2003 killed the
office shortbar, though.)

Stuart,
In case you did not noticed it, but Dave's advice says "inside Word". Excel does not have this setting, but reads from the Office setting.

NickHK

 

[Stuart]

Stuck with 2003, I'm afraid.

Regards.

Another way to get to that setting (if your version of office supports it
and
you have it installed) is through the Office shortcut bar. (xl2003 killed
the
office shortbar, though.)

 

[Dave Peterson]

That's an odd way to characterize the latest and greatest windows version of
office <vbg>.

 

[JE McGimpsey]

Based on my clients, not *that* odd...<g>