Is there a way to search for how many sheets in a directory of Excel workbooks?

I have already posted this on the mrexcel.com support forum, but thought I would try it here as well.
I have a drive where there are over a thousand Excel workbooks, but I am only interested in the ones that have more than one sheet or tab. Is there a way to search for those?

There's a script-column here which reports the sheet names of Excel files in a column:

It should be easy to adapt that to report a count of sheets/tabs instead or the names. You could then search based on that (via Find Files > Advanced, and the Script Column clause type).

This add-in will make the info available:

1 Like