How to search contents of excel docs in a folder

So i need to find a way to search a folder of 100's of excel docs for specific model numbers.

I would like to be able to just search in the folder for the part number and not have to look through my notes to find 1 part number..

I thought that i could save the excel Doc as text and excel going forward, so both will be in the folder. so when i search for a part number in the folder the text doc shows up so i know which excel doc its in. but that would not help me for the 100s of files that are currently in there.

Is there a setting i can change that would enable this? or is there a way through RUN CMD to convert all to text?

You can use this macro: (not mine, I found it online somewhere but don't remember where)

Please Login or Register  to view this content.