Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2006

Tip: Looking for answers? Try searching our database.

Transferring a Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim D. - 21 Sep 2006 21:46 GMT
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.
Jonathan West - 21 Sep 2006 22:11 GMT
>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

larrysulky@gmail.com - 21 Sep 2006 22:25 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.