I have several hundred workbooks. I want to extract data from
all workbooks and ADO seems to be faster than opening and
closing each workbook. BTW, each workbook that I'm getting
data from contains over 300K bytes. So, each file is big and
contains macros. Wouldnt it be faster just to use ADO in
this case?


"norie" wrote in message
...
Robert

No, closing the <brecordset</b does not close the connection - well
it shouldn't be.

I'm also still a bit confused why you would want to use ADO to extract
only a few cells from a worksheet.

The easiest, probably the quickest and maybe the least problematic way
to do that would be to open the workbook, get the data, close the
workbook...