PDA

View Full Version : Search folder with a value in cell



mikke3141
06-11-2010, 11:59 AM
What would be the best code to go through all the workbooks in a folder and show the workbooks that have a specific text in any cells in any sheets in any workbooks in the folder specified? Thank you for your help,

Mike

GTO
06-11-2010, 12:04 PM
Greetings Mike,

Maybe just me, but a tad more detail would seem helpful. Are we looking for a whole match against each cell, or a substring? What are we doing upon finding whichever we are looking for, etc...

Have you attempted any code thus far?

Mark

mikke3141
06-11-2010, 12:15 PM
To have a find in any cell in the workbooks in the folder that have an exact match.

I was requested to find the excel file that had the number 45134234 in any cell in the folder. Windows did not support the request with any standard tools.

Bob Phillips
06-11-2010, 12:16 PM
See my response to minger15's post, it should get you started.