More sophisticated Macro for customizing doc's

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sararose15 - 19 Jul 2005 19:28 GMT

I have a regular doc that I've been able to run a basic "Fill-in" Macro on to
help me do routine customizations of the doc. I'm just new to VBA and just
copied and pasted the macro, but now I'm hoping to get it to be a little more
sophisticated. Can I get the Macro to recognize that there are similar
prompts throughout the document (ex. "Company Name") and get it to replace
them all at once throughout?

Reply to this Message

Charles Kenyon - 19 Jul 2005 19:50 GMT

From the FAQ

How can I enter something once in a document and have it repeat elsewhere?
http://gregmaxey.mvps.org/Repeating_Data.htm

You should _not_ be using a macro to gather information. You should be using
one of:
1) online form
2) macrobutton fields
3) fill-in or ask fields, or
4) userform

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.

>I have a regular doc that I've been able to run a basic "Fill-in" Macro on
>to
[quoted text clipped - 4 lines]
> prompts throughout the document (ex. "Company Name") and get it to replace
> them all at once throughout?

Reply to this Message

Doug Robbins - 19 Jul 2005 21:45 GMT

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Reply to this Message