Need to export a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 26 Apr 2004 21:39 GMT

I have created a macro that mass-replaces a series of
characters in a document. What I need to be able to do is
send that marco to folks, and have them "install" it into
Word. Then they can load their doc, and press ALT+F12 (the
key I assigned it to) and do the REPLACE.

I cannot for the life of me figure out how to
Import/Export the thing. It's recorded via RECORD MACRO,
and not written in VBA (I don't know how to do that yet).

Any tips or assistance would be greatly appreciated!

TIA!

Reply to this Message

Doug Robbins - Word MVP - 27 Apr 2004 02:18 GMT

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

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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have created a macro that mass-replaces a series of
> characters in a document. What I need to be able to do is
[quoted text clipped - 9 lines]
>
> TIA!

Reply to this Message

Dennis - 27 Apr 2004 17:48 GMT

THANKS! That did the trick. Now, I have one other issue:

I had assigned that macro to ALT+F12 on my PC, but that
assignment doesn't seem to have "stuck" when imported to
someone else's PC. Is there some way I can force that
assignment? (ALT+F12 is unassigned by default in Word 2002)

Thanks again!

Dennis

>-----Original Message-----
>See the article "Distributing macros to other users" at:
[quoted text clipped - 16 lines]
>
>.

Reply to this Message

Charles Kenyon - 27 Apr 2004 20:44 GMT

Tools => Customize => Keyboard

Make sure that the template you are saving in is the one you want.

Otherwise you can use the Shortcut Organizer.
http://www.chriswoodman.co.uk/Shortcut%20Organizer.htm

Signature

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

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
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.

> THANKS! That did the trick. Now, I have one other issue:
>
[quoted text clipped - 39 lines]
> >
> >.

Reply to this Message