Search word docs in a folder for certain text.

[neemi]

I have a requirement to create an automated search of word doc's in a folder for a particular word or pharse. Similar to how it is doe in windows, but I need this automated as part of my function.

I have a table created with the path names and file names of the documents to search. then I need to carry out the search and if a match is found the record in the table flagged.

But I need help wth carrying out the search of the text in vba.

advise apreciated.

regards,
neemi

 

[neemi]

sorry forgot to say the search needs to be carried out from access. I am currently using 2002

 

[fumei]

If the text is in the body of the documents, you will need to make an instance of Word, open the documents and search for the text. You can use standard search routines to do so.

With Selection.Find
  .Text = "search string"
  .Execute
  If .Found = True Then
     ' set your flag
  End If
End With

Gerry
My paintings and sculpture

 

[combo]

In xp you can search inside documents:

With Application.FileSearch
    .NewSearch
    .LookIn = "c:\test"
    .SearchSubFolders = True
    .FileType = msoFileTypeWordDocuments
    .MatchTextExactly = True
    .TextOrProperty = "text to find"
    .Execute
    For i = 1 To .FoundFiles.Count
        MsgBox .FoundFiles(i)
    Next i
End With

combo