I have written a Word macro that another user needs to have on his computer.
I saved the macro in normal.dot. How do I go about transferring the macro to
the other person? Thanks for any help.
>I have written a Word macro that another user needs to have on his
>computer.
> I saved the macro in normal.dot. How do I go about transferring the macro
> to
> the other person? Thanks for any help.
Distributing macros to other users
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
1) Open Word. This will open a blank document that has Normal.dot as
the attached template.
2) Click Alt+F8 to get a macro list.
3) Constrain the macro list to only macros from Normal.dot.
4) Highlight your macro and click Edit. This will open the Visual Basic
Editor at that macro.
5) Copy your macro to the Windows clipboard (Ctrl+A, Ctrl+C).
6) Return to the Word window and Save As a .dot template file, choosing
a name that seems reasonable to you.
7) Click Alt+F8 to get a macro list.
8) This time, constrain the macro list to only macros from your new
template. It will be an empty list.
9) Type the name of your macro in the input field in the macro list,
and hit the Create button. This will open the VBE at a new, but mostly
empty, macro.
10) Paste your macro from the Windows clipboard over the mostly empty
macro.
11) Save the template.
12) Exit Word.
13) Give your user the new template that you've created, and have him
put it in his Templates folder.
14) Promise never to save macros in Normal.dot again.
--larry
Jim D. - 22 Sep 2006 14:19 GMT
Many thanks to both people who replied. Very helpful.
Jim Dutton
=====================
> 1) Open Word. This will open a blank document that has Normal.dot as
> the attached template.
[quoted text clipped - 20 lines]
>
> --larry