Distributing Macro.....

[Al]

Hi Folks,

I have seen a few ways to distribute a template and macro. Most let the
user save the macro in their \office\templates directory.

Some of our users are not even capable of getting that right!!

What I was wondering was....if the templates was put on a shared directory
on a
server, could the users be emailed a template that when double clicked in
the email
opened in word and autoexec code to copy the templates from h:\whereever to
s:\office\templates?

Also would anyone know the way to write code that created a button on the
word toolbar which
calls one of the new templates? Ie a button linked to code which calls the
new template?

Cheers,

-Al

 

[Peter Hewett]

Hi Al

If your on a net work then normally Tools>Options>File Locations>Workgroup
Templates points to a shared network folder that all users can access for
common/shared templates. If you don't have your system(s) set up in this way
you should possibly consider doing so.

The other option is to use a login script. In most environments when a user
logs on to their networked computer it executes a login script. Have this
script copy the template.

HTH + Cheers - Peter

 

[Jonathan West]

Hi Al,

This article might be of some help to you. If you have further questions,
feel free to ask back here.

Distributing macros to other users
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

 

[Al]

So to add a button to every users toolbar which will appear everytime they
start word I assume means a change to the normal.dot?

Is it possible to create a macro that installs such a button?

-Al

 

[Charles Kenyon]

Nope, you do _not_ want to change normal.dot. You can put your custom
toolbar and customizations to built-in toolbars in a global template which
is loaded into your users' machines if it is in their Word Startup folder.
You can make the change to the template manually using the customize dialog.

You can put a command into each user's login script to update their Startup
folder from the network upon startup. (This lets you edit your global
template while they have Word open. If you simply have them set their
Startup folder as your network folder, your global will be locked for
editing while anyone has Word open.)
--

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[Jonathan West]

So to add a button to every users toolbar which will appear everytime they
start word I assume means a change to the normal.dot?

No. Add the toolbar into a separate template. Load the template into each
user's Word Startup folder. Templates in the startup folder are loaded as
addins automatically when word is started.

Use login scripts or other means to copy new templates into the startup
folder and/or user templates folder.

 

[Chad Knudson]

I wrote a small ActiveX control that I put on a webpage and users within the
organization just click a button on the web page and the ActiveX control
takes care of downloading the most recent version of the template and
launching Word to create a new document based on that template. This solved
a number of problems for us such as keeping everybody in sync using the most
recent version of the template as well as prevented us from having to have
IT staff or the end users worry about installing the template or
re-configuring Word.