searching for a specific part# in multiple workbooks.

[Simi]

I'm not sure if this should be here or probably in the VBA section.
Is there an easy way to look for a term, specifically a part#, in multiple files?
The part# may not be the only information in a specific cell, and may not be in the same range on each sheet.
I have multiple workbooks, each with 1 sheet.

I am in need of finding all my files that contain a specific part#.

So I would like to generate a list of file names if the file contains my part#.

Thank you,

Simi

 

[Kelvin Maed]

i would use windows search if you are on windows. use the stupid dog to choose in a file, point to a folder containing the term and search

may only work if file indexing is on.

 

[Simi]

Kelvin, thanks for the response.
What I actually needed ended up being a lot more complex than just finding the files.

I was able to accomplish this with some VBA, and manual filtering/sorting.