Distributing Template

L

LiamD

New Member
Joined
Sep 3, 2006
Messages
34
I have a template file that I have to give out to a number of users. In general, the users have limited computer knowledge or skills.

What is the most reliable way for these users to install the template spreadsheet on their own machines?

The users use different version of Excel (2000, 2003, 2007) - is there a common folder that gets examined by each version of Excel.

I can think of the following ways:
- Creating a full windows installer to add the template (setup.exe)
- Create a simple batch file to copy to the template folder (e.g. install.bat)
- Get the user to copy to the template folder

Which would be the best solution for an inexperienced group of users - I want to minimise my "technical support" during the distribution of the template.

Thanks,
Liam
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
If you create it in 2000 you'd be OK distributing to '03 & '07 users. As for distributing, why not just e-mail it? Are they skilled enough to open a file and save it following instructions?

(If not you should take away any sharp objects they might have and their car keys...)

If you can set up a way to automate it though then why not?

HTH,

Smitty
 
Upvote 0
OK. Perhaps my basic question relates to which folder I should copy it to.

Can I use this folder for all versions of

C:\Documents and Settings\{USERNAME}\Application Data\Microsoft\Templates

or would this be better

C:\Program Files\Microsoft Office\Templates\1033

or perhaps another folder.

Remember it should be available for 2000, 2003 and 2007.

Thanks
Liam
 
Upvote 0
From a programming/distribution perspective, I would imagine that the second option would be the easier choice of the two.

Smitty
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
Call TekXL Screen Capture from user-defined macro?
Replies
1
Views
517
TheWaterbug
T
S
  • Question
Large project, first time calling subs and using error handling
Replies
0
Views
353
Shakeable_Drip
S
R
  • Question
Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.
Replies
1
Views
962
RajK2005
R
S
  • Solved
VBA copy template sheet to new monthly workbook with daily sheets tabname and header A2:J2 named as "dd mm yyyy" + autosave filename predefined
Replies
4
Views
585
mumps
mumps
H
  • Solved
Macros stopped working from buttons
Replies
5
Views
5K
Fluff
Fluff

Forum statistics

Threads
1,215,064
Messages
6,122,942
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top