Find and Replace using Autocorrect "mapping table" ??

[DocA]

Hi,

I want to be able to perform a multiple Find and Replace based on the values
in a hypothetical two column table.

For example,

COLUMN1 COLUMN2
dog cat
blue yellow
9 4
France Spain

ie. Find "dog" replace with "cat" etc

In reality this table will have about 100 entries and I will need to perform
all these operations on dozens of ASCII files.

My original idea was to create the two columns in Excel or Word then write a
macro to open each text file and do a find and replace of each occurrence
based on the values in the two columns. But before venturing down that road
it occurred to me that I might possibly be able to do what I want instead
using the autocorrect feature in Word. What I have in mind is deleting all
autocorrect entries then entering the values I want to map and then running
the autocorrect. However, it doesn't seem possible to "force run" the
autocorrect on the entire text. I can't see how to do this in either the
program or VBA Help, but I thought it was worth asking as I am somewhat
rusty at coding and if I have to do it the long way it will take me a while

Any help would be appreciated.

Thanks,

Adrian

 

[Doug Robbins]

Stick with your original idea.

See the article "Find & ReplaceAll on a batch of documents in the same
folder" at:

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[DocA]

Okay. Thanks for the advice.

Adrian

Stick with your original idea.

See the article "Find & ReplaceAll on a batch of documents in the same
folder" at:

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP