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
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
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
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.
See my response to minger15's post, it should get you started.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber