Scan the file contents for a word and list them if it exists

[Sanmrxl]

I require to list all files which have the text "Request" in its contents
(for eg . if a doc file "EXAMPLE.doc" contains the word "Request" in its contents, it should get listed).

All this without opening the files in the directory or subdirectory.

Please note -
1) the file type could be anything from DOC, XL, PPT ( mostly MSoffice files)

2) the requirement is not to scan the file name -- it is to scan the contents of the file for the given word ( "Request" as stated above, for example)

Thanks

 

[Scott Huish]

What version of Excel are you using?

 

[Sanmrxl]

I am using XL in Windows XP and Windows NT

 

[Scott Huish]

OK, change path as appropriate, although if you had in mind your whole hard drive I have no idea how long this is going to take, but it will probably be a very long time.

Sub test()
Dim i As Long
With Application.FileSearch
    .NewSearch
    .LookIn = "C:\test"
    .SearchSubFolders = True
    .TextOrProperty = "Request"
    If .Execute() > 0 Then
        For i = 1 To .FoundFiles.Count
            Range("A" & Rows.Count).End(xlUp).Offset(1) = .FoundFiles(i)
        Next i
    End If
End With
End Sub

 

[PaddyD]

I assume you know this is a standard feature that, depending on the use you're putting the results to, doesn't need excel's intervention...

 

[Sanmrxl]

thanks for your help both paddy and hotpepper.
I shall try it