VBA: Search string in files and list it's folders

[inddon]

Hello There,

I have a column (A) which is list of one word, Column (B) is the directory-File name.

I would like to have a VBA sample which would do the following:
1. Search Directory Name- C:\Files

2. For every word in column (A), it should search the files in the above directory and it's sub-directories. If it finds the word in any or multiple files, then it should list the directory and the file name in column (B)

Could you please advice, how this can be achieved using VBA?

Look forward to hearing from you.

Regards,
Don

 

[Chihiro]

Why use vba? There's ready made solution in Windows Explorer.

Alternately GREP or other tools will do the job and are much faster.

If you need vba, read the link. It's specifically for Log file, but you can do similar for other file types.
https://stackoverflow.com/questions...tring-in-one-of-many-text-log-files-using-vba