View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Denis Béland Denis Béland is offline
external usenet poster
 
Posts: 4
Default ADO Recordset using Excel as a database. Can't free the memory onc

Yes i did just that as a first solution.

But the code was getting long and difficult to maintain and to update.

This is true when you have to use more that 3 column to filter and when
you have to combine OR and AND condition in the same filter.

By doing this ADO solution i was hoping to reduce the leght of the code
and simplify it for future maintnance.

The code is much lither and easier to follow, and works just fine but
only for the memory problem!

Thanks





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