Hi Cool,

Thank you very much for your great help! I got my function running now~!

Also thanks Jamie to participated in this thread~

K.K. :D


"Jamie Collins" wrote in message
om...
keepITcool wrote ...

I'm an ADO fan, dont get me wrong.
I'm a decent coder too, and I know that I've got to close connections
and objects.

You must have missed the discussion about this yesterday:


http://groups.google.com/groups?thre...GP09.p hx.gbl

arno finally agreed with me that closing ADO's connections and objects
has no effect.

I was referring to this BUG:
http://support.microsoft.com/default...b;en-us;319998

Yep, I'm familiar with that article. Below I've emphasized the
important bit:

"When you retrieve a Microsoft ActiveX Data Objects (ADO) Recordset
from an Excel worksheet <emphasis that is open in Excel
</emphasis,
a memory leak occurs in the Excel process."

And you missed the important bit from the RESOLUTION:

"query the Excel worksheet only while the file is not open in
Excel."

Jamie.

--