Checking specific text string in excel files stored in a folder

[AG]

Hi,
I need to write a code that can do the following:
1) prompt user to select a particular folder
2) search for a particular text string, for e.g., ABCD in all the
excel files in that folder (the number of files in the folder will
vary and so does the names of the files). Is it possible to specify
the string that we want to search on the fly when macro is run?
3) create a simple report that contains the filename in one column and
yes / no in the second column that tell me which file names contain
that keyword (it will be great if the path of the file can be recorded
in the 3rd column that we can click to open the file).

Currently we do this manually and I am looking for a way to automate
the same.

Any help on this will be much appreciated. Thanks.

 

[AG]

One thing I forgot to mention is once the user selects the primary
folder then there will be subfolders that contain the excel files. The
name and number of subfolders and the excel files inside them both
vary. Capturing the path to the excel files will really help us.
Thanks.

 

[AG]

Hi,
can someone please help me with the above problem? Many thanks.

 

[Dave Peterson]

Maybe you could use Chip Pearson's addin:
http://www.cpearson.com/Excel/FolderTree.aspx

Get your list (in column A) and use a formula like:
=countif(a1,"*abcd*")>0
in column B

 

[AG]

Thank you Dave. It helped a lot.