Interesting,

Note they're speaking to querying an open Excel file. One of the benefits of
using ADO to query a spreadsheet is that the file can (and apparently should)
be closed.

Not to mention that ADO is extremely fast.

Cheers,
Nate

"Jamie Collins" wrote:


Nate Oliver wrote:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
ThisWorkbook.FullName & ";Extended Properties=Excel 8.0;"

More info on why this is a bad idea can be found he

BUG: Memory leak occurs when you query an open Excel worksheet by using
ActiveX Data Objects (ADO)

http://support.microsoft.com/default...;en-us;Q319998

Jamie.

--