How to Launch UserForm & Template

[LizW]

I created a userform which feeds different fields into a table in Word. It
works great on my computer because I simply click File, New and the template
appears on the right pane in the list. When I click on it, the form pops up
and everything works great.

However, I need to install this on many computers in our office. I have
moved the form to the network shared drive but I want to create a macro that,
in effect, does a "File, New, Template" at the user's desk without copying
the template to everyone's local computer, but instead accesses the
userform.dot file on the network. Of course, the templates that show on each
person's computer are only local to each system.

I am familiar with the Organizer, and copying macros between templates, and
have set up toolbars with macro buttons that bring in documents but I'm
having a hard time getting access to creating a new document based on this
template by automating it with a macro at different stations.

Any help would be greatly appreciated.

 

[Chuck]

If you want users to be able to create new documents based on your template
the easiest way is to copy the template to each user's local Templates
folder. Alternatively you could try leaving a (read-only) copy in workgroup
templates location (Tools>Options>File locations>Workgroup templates).

You can also write code to create documents based on a template stored
anywhere but from your post it's not clear what advantage that would offer.

If you're talking about using the Organizer to copy macros between templates
(presumably to users' global templates which are stored on users' local
drives) then you might as well save yourself a lot of effort and simply copy
the template down to a local Templates folder. A logon script would make
updating the local files easy by automatically copying them to the local
machines from your server.

 

[Charles Kenyon]

Consider putting your template in the Workgroup templates folder. For more
on the different kinds of templates, tabs on the file new dialog, and
locations of templates folders see
http://addbalance.com/usersguide/templates.htm.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: 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.