Visual Basic / Word Macro Help - Massive Multiple Word Find / Replace

Question

Hello All,

I am very new to the macro creation / Visual Basic world, but I have a great need that requires me to understand it, or at least to use a macro for this task.

I have many huge documents with similar word misspelling, errors, etc, and I believe that using a macro to find/replace multiple words at one time will be a huge help.  I'm talking about thousands of words.  I've already done one document so far, and it's taken me weeks. 

I found many sample macros on this site and through different web searches that claim to do what I need.  But I can't seem to get any of them to work.

And I think it's either because I don't know the "basics" of Visual Basic, or the code may be wrong.  (But there's no way for me to tell.)

What I would like to do is make a list, to input into a macro, of words that could possibly be among those misspelled, and another list of what they should be.  IE: List #1 would have the word "neighbour" and List #2 would have the word "neighbor".  And this list would have thousands of words.

In my desperation, I've also tried using Notepad++, but I think this is only useful up to 9 words.  :(

Anyway, if someone has any ideas, or can point me to a macro (I'm sure it's already been done) that works, I would truly be thankful.

PS. I have access to both Office 2010 and 2013.

Answer 1

Something seems to have disappeared from the original code in the link. I've updated it now, so try the update.

Answer 2

See: http://www.msofficeforums.com/word-vba/12803-find-replace.html#post34254

Answer 3

You did it!!!

Brilliant work!

Thanks!

Now I will just be filling up my Excel file with more and more words.  I am extremely happy!