Where found in multiple folders

Good afternoon everyone,
In a cell I have a text string...C00023. I would like to have some VBA code or other way which will take that string and search in a specific folder which contains sub-folders and return a list of all the excel files which contain that string. I can do a search with the microsoft search engine to obtain the list, so if it that can be set up to run with code, that should be good. I have searched forums and googled but trying to phrase the question clutters the results.

Any help would be appreciated.

Ken

Thanks for the reponses. But it does not seem either helped Dave, yours looked promising. I placed the code in the ThisWorkbook and a seperate module. I placed a folder in my directory called C00023 and it did not work. I actually would like it to list the Excel files which have the text string C00023 located somewhere in the file.
To give a better idea C00023 is our internal part number for a capacitor. I have a folder which contains individual Bill of Material Excel files for our different products. Some of which are in sub-folder. I would like to type C00023 in cell A1 and have it search and list all the files which contain that text in cell B1.
Thank you for the help.
Ken

I did change the path. Does it make a difference if it is on a network drive and not my computer? Sorry that may have been important. With the VBA box open I selected the code and hit run and nothing happens.

Ah, I see. He wants to do a text search within the file itself, not just the filename.

For that you would need to open each file, search it, then close and move on. Maybe there is an API or two that can be used to mimic the File Search done at the Windows level. I don't know.