We have a few hundred Excel files, whose structure is the same: a one page
numeric data worksheet and a few graphs. We like to extract some numeric
data out of some of these files.

A colleague has written an Excel macro to do it, and he commented that it is
slow as it takes a min or two in each run. And he needs to run it multiple
times. I read somewhere before that we can query an Excel file. I saw an
example for querying one file. I wonder would it be possible and practical
to query multiple Excel files?

Or any idea on how best to extract data in multiple Excel files?

Thnaks,

Q