Excel and Word

I'm wanting to write a macro for Excel that will search through a directory of Word documents. I want to be prompted for a portion of a string (like a search function), and then it will take that search criteria and search through every Word document until it finds it. Then I want it to either leave that Word doc open (probably the easiest), or take the entire string (sentence) as well as the Word doc name and put them into a spreadsheet, each time offsetting by 1 row.


This probably is not the best description of what I'm wanting, but any help is appreciated. I'm not sure if/how Excel can be integrated with Word.


Thanks,

DejaVu

Just keeping the question alive.

Anyone know how to search through a directory of Word documents?

I'm wanting it to basically look through each doc as if I were to open each one, and do a search (Control+F). Then if it finds it, to leave the word doc open and exit the sub.