Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
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 wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
Thanks.
Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
That was part of what I intended. The remaining part is doing the same thing
for all your users. Stuart wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
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 On Tue, 3 May 2005 20:36:02 +0100, "Stuart" wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
Many thanks.
Did notice. Regards. "NickHK" wrote in message ... 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 On Tue, 3 May 2005 20:36:02 +0100, "Stuart" wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
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.) NickHK wrote: 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 On Tue, 3 May 2005 20:36:02 +0100, "Stuart" wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
Stuck with 2003, I'm afraid.
Regards. "Dave Peterson" wrote in message ... 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.) NickHK wrote: 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 On Tue, 3 May 2005 20:36:02 +0100, "Stuart" wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
That's an odd way to characterize the latest and greatest windows version of
office <vbg. Stuart wrote: Stuck with 2003, I'm afraid. Regards. "Dave Peterson" wrote in message ... 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.) NickHK wrote: 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 On Tue, 3 May 2005 20:36:02 +0100, "Stuart" wrote: Thanks. Ok did that, then restarted Excel. Clicked FileNew and in the New Workbook pane there was an entry for TemplatesOn my computer. My file was listed there. Was that as you intended........sorry, bit confused about this. Regards. "Dave Peterson" wrote in message ... 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template questions
Based on my clients, not *that* odd...<g
In article , Dave Peterson wrote: That's an odd way to characterize the latest and greatest windows version of office <vbg. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Excel template and access questions | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |