If you have a few hundred workbook that take ONLY two minutes to open and
close that is pretty good. Thats a 1/2 second a file.

When you say querying I think you mean accessing the files without opening
the files. These are done with database instructtions not a query. You
would create an Access Object and usingg Access Macro instructions (inside
excel) read the data. It is a little bit harder to get the data in this
fashion because in Access you have to move down X number of rows and then
move Y number of columns to get the data. In Excel you can randomly move to
any cells. I'm not sure how much improvement you will really get because you
will still havve to connect to each file.

"Q" wrote:

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