Is there some function or code that can be used in place of:

strExcelSQL = "SELECT * FROM [Sheet1$]"

"Don Guillett" wrote in message ...
try

Sheets(1).Activate

Eek!

BUG: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
http://support.microsoft.com/default...;en-us;Q319998

--