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 / November 2007

Tip: Looking for answers? Try searching our database.

Transferring Macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
McRibIsBack - 08 Nov 2007 13:20 GMT
I have created a simple Macro in Word to record my keystrokes in order to
automate a task of course. However, what i need to do next is see if these
Macros can be transferred to other PCs in my work environment so that I don't
have to recreate the same Macros on each PC in our office.

Where does word save these Macros? and Can I just transfer them via E-Mail
or a shared drive source and simply assign the appropriate keystroke/toolbar
to the macro as normal?

Thanks,

McRib
Lene Fredborg - 08 Nov 2007 14:03 GMT
See these articles:

What do Templates and Add-ins store?
http://word.mvps.org/FAQs/Customization/WhatTemplatesStore.htm

Distributing macros to other users:
http://word.mvps.org/FAQs/MacrosVBA/index.htm

Signature

Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word

> I have created a simple Macro in Word to record my keystrokes in order to
> automate a task of course. However, what i need to do next is see if these
[quoted text clipped - 8 lines]
>  
> McRib
McRibIsBack - 08 Nov 2007 14:36 GMT
hmm...well according to the article i would have to save the macros into a
template as opposed to the "Normal.dot" file to reduce chaos when
transferring the Macro to other users.  However, i believe this then involves
having to modify a template via VBS/VBA and I am not familiar enough with VBS
code to do that... :-(
Signature

McRib

> See these articles:
>
[quoted text clipped - 16 lines]
> >  
> > McRib
Jonathan West - 08 Nov 2007 17:33 GMT
> hmm...well according to the article i would have to save the macros into a
> template as opposed to the "Normal.dot" file to reduce chaos when
> transferring the Macro to other users.

Correct.

> However, i believe this then involves
> having to modify a template via VBS/VBA and I am not familiar enough with
> VBS
> code to do that... :-(

Did you just use the macro recorder to create your macros? If so, just
repeat the steps, but specify a particular template when asked where to save
the macro.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Graham Mayor - 08 Nov 2007 14:19 GMT
See http://www.gmayor.com/installing_macro.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have created a simple Macro in Word to record my keystrokes in
> order to automate a task of course. However, what i need to do next
[quoted text clipped - 9 lines]
>
> McRib
 
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.