Hi snb,

Welcome to ExcelFox !!

MS has documented that there is a memory leakage while you querying data from an open Excel.

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