Hi everyone, I'm new here. Been an Excel user for 10 years and over the time learned to write some basic (by basic I mean really really basic) VBA to support my work.
I'm exploring the idea to use ADO connection to query an open workbook, which is not new at all. I've avoided it in the past because I read about the bug of memory leak, I understand there are two possible workarounds (SELECT INTO, and SAVECOPYAS), but I find them not very practical in my situation.
Recently I read somewhere that with Microsoft.ACE.OLEDB.12.0 this memory leak is no longer a problem, so I created a workbook with ADO and several tables all less than 1000 rows and 20 columns, I then ran some queries on them over and over again and did not experience the memory leak issue. I checked VBE and memory usage, all seemed normal.
Is the memory leak issue really fixed with Microsoft.ACE.OLEDB.12.0? That would be great as I find the ADO extremely useful.
Your help is much appreciated. I'm using Excel 2010 SP1 32-bit.
Thanks!
Bookmarks