Hi Nishant,

It's recommend that not to query using ADO on an open excel workbook. More details can be found here;

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


You may also interested this link: http://www.excelfox.com/forum/f12/de...-formulas-111/