Find and Replace in Word from list in Excel

B

Brent

Using Office Pro 2003. I have about 50 work related procedures (WORD) that
we have recently changed the procedure numbering system from XX-Y-#### to a
decimel system (6.4.321). Inside each of the procedures there is a
possibility that other procedures are referenced in the old method.
Additionally, some of the procedure titles may need to be modified as well.
I have a list (Excel) of old procedure numbers, new procedure numbers, new
names and old name variations. Is it possible to somehow get the two
documents to work together to find and replace the old with the new in the
Word Document? Hopefully with as little user interface as possible. Oh, one
other thing -- it would be nice to record what changes were made but isn't
essential.
 
G

Gavin

Sorry to mis-post, but I haven't been able to get in contact with you
any other way. A while ago you placed a post regarding EMM and
faulting module adsldp. I'm getting exactly the same error. Did you
ever get a resolution?

Thanks in advance ... Gavin.

PS - Just send direct to my email address so that we don't bore the
good folk on this group.
 
A

ANONYMOUS

What exactly have you got in WORD? Is it just a list of old numbers or
does it also contain other characters? Also, How long is the list in
Excel?

It looks like a MACRO will do this quite easily; For this you need to
post this on a special Newsgroup.

http://peach.ease.lsoft.com/scripts/wa.exe?A1=ind0604a&L=excel-l


Just make up a dummy username and provide a proper email (free web based
email like hotmail/yahoo will do for this).

hth
 
B

Brent

My WORD documents contain full text procedures including letters, numbers and
text. Basically a technical document describing how to run a machine, for
example. The EXCEL sheet contains columns of information like "Old Procedure
#"; "New Procedure #"; "New Procedure Name" and possible variations in the
name. All of the file names have been altered to include the "Old Procedure
#" and the "New Procedure #." There are approximately 50 or more procedures
that the following needs to be performed on:

Step 1-
Change each File name from the combination file name to the new file name
(example: From "6.4.321 AB-P-124, Power Winch Operation" to "6.4.321, Power
Winch Operation") Note: "6.4.321" is new Procedure #, "AB-P-124" is Old
Procedure #, and "Power Winch Operation" is the New Procedure Name.
Step 2-
Look inside the Word Document for any reference to the Old Procedure # or
name and change it to the New Procedure # and Name.

I'm very new at Macros (have only recorded a few within Word and Excel) and
have no experience writing script in Java, Visual Basic or any other. What I
need is to know what would work best for automating this task and learn how
to make it happen. E-mail to [email protected]
--
Thanks,
Brent
Willing to learn with moderate experience!


ANONYMOUS said:
What exactly have you got in WORD? Is it just a list of old numbers or
does it also contain other characters? Also, How long is the list in
Excel?

It looks like a MACRO will do this quite easily; For this you need to
post this on a special Newsgroup.

http://peach.ease.lsoft.com/scripts/wa.exe?A1=ind0604a&L=excel-l


Just make up a dummy username and provide a proper email (free web based
email like hotmail/yahoo will do for this).

hth
Click to expand...
 
Top