I got this question from a user and I have to say I don’t have a clue from where I could begin with this. Would you guys have any idea on how I could proceed ?
**Situation:**
————–
What I have is an excel list with words (filed names of database records) on one side, and on the other side I have a series of word documents (The FRS and ODD specifications of these same products)
What I wanted to do is to complete that excel list with information whether the word appears in the document (adding one column per document and keep a yes/no
list) Doing this manual would be a very time consuming job.
**Idea: **
———-
What I would like to do is write a VB Macro in Excel that is something like:
Loop (for each documentin a directory)
Loop (for each cell in column B)
Cell xy = Searching Word doc for word (column B)
endloop
endloop
So I have two things that I don’t know yet and for which I’m looking to you for
help:
1) What function canI use to et all files in a directory
2) Is there a function I can use to search is a word document
That’s the mail I got,… any idea ?
i’ll give you 200 points for this please…