Transferring a Macro

J

Jim D.

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

larrysulky

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
 
J

Jim D.

Many thanks to both people who replied. Very helpful.

Jim Dutton
=====================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top