Find / Replace with Verify

[JSR]

I am looking for a little help manipulating two word documents with
VBA. My VBA experience is limited to basic Excel functions that were
pretty straight forward.

I want to take a source file containing the VBA code and a list of
acronyms with definitions and do a search with a replace option on a
target file. For instance, if the source file contain "US - United
States" in a table, I want the code to open the target file (Word
Document) and search it for US, then once found display a message box
that gives you the option to replace it with United States or continue
searching. This list of Acronyms may contain several hundred or more
and will change periodically.

If it is easier to manipulate, the acronym list could be kept in an
Excel document.

Could someone point me in the right direction. I would also be greatful
if you could also point me in the direction of VBA reference books that
may help better undertand the process.

THANKS!

 

[Dave Lett]

Hi,

You wrote: "then once found display a message box that gives you the option
to replace it with United States or continue searching."

1) Replace it only or all instances of US with United States?
2) Continue searching for US or continue searching for the next word in the
"target file"?
3) Is a target file required? That is, if it can all be in the VBA code,
would that be acceptable?

Dave

 

[JSR]

Thanks Dave for replying. The answer to your questions are as follows:

1)Replace it only
2)Continue Searching for US until all have been found then start
searching for the next word in the target file
3)I need to keep them seperate for updating purposes. I am wanting the
VBA code and the acronym list to be in one file then I want to be able
to easily compare it to a Word document. I also want to pass it on to
someone else and them be able to use it without too much effort.