Distributing a macro and form

[Bob]

I have a complex macro that (now) resides in the code for a user form,
frmMain. I have another macro that simply calls the form (frmMain.show).

I need to give the form and calling macro to a few departments. Is there an
"easy" way to send the files and tell people how to install them? I know
how to export the form to a .frm file and the macro to a .bas file, and can
email those (do I have to send the .frx, as well?). How do I have people
"install" the form and macro? I can give them instructions on how to open
the VB editor and import (or can do it for them), but was wondering if there
is an easier way.

Actually, if I export all my macros and delete all but the one the other
folks need, how do I have them import just that macro without overwriting
other macros they may have?

Thanks,
Bob

 

[Charles Kenyon]

You could distribute your template with only the form and macros you want
for use as an Add-In. It goes in the user's word startup folder. See
http://addbalance.com/word/movetotemplate.htm for step-by-step instructions
on moving / sharing / copying / backing-up customizations including
AutoText, AutoCorrect, keyboard assignments, toolbars, macros, userforms,
etc.
--

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


--------- --------- --------- --------- --------- ---------
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.

 

[Doug Robbins - Word MVP]

The form and the macros should all be in a template that you distribute to
your users.

See the article "Distributing macros to other users" at:

http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP