Help! Help! USing Excel/ VBA find a series of words and return the page # and Line #

[zaccari5]

Help,

I have a list of words (about 800 words in the list) in Excel that I want to search/find a 200 page word doc. For each word found I want to:

Highlight the word in the doc
For each instance found save on defined Excel worksheet the word, the page# and the line#

[SamT]

From the Windows Programs menu, Open Word.

Start recording a Macro.

Using only the Keyboard in while in the Word Window,

• Open a copy of the 200 page Word Doc.
• Find and highlight one of the words in your list.
• find and highlight the next instance.
• repeat one more time.
• Close and save the copy.

Now you can use the mouse to stop recording the Macro.

Open Word VBA, copy the macro and in our Forum Editor, Click the # icon on the menu, then simply press Ctrl+V to paste your code in between the CODE Tags.