Thread: ADO Recordset using Excel as a database. Can't free the memory once opperation is over?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Denis[_6_] Denis[_6_] is offline
external usenet poster
  
Posts: 1
Default ADO Recordset using Excel as a database. Can't free the memory
Hi Sharad.

I am using Exel 2002. Maybe it is corrected with 2003

In the article i used the second suggestion that is to do a .SaveCopyAs
and then i connect to that saved copy.

I did not chage anything in the code other that add one line before
opening the connection.

wrkBx.SaveCopyAs Application.Path & "\Data.xls"


Denis

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote