VBA throws Out of Memory error.The system is using Excel to generate the report which reads the data from database. The VBA forms are used to get the user input. The data access method is in .Net class. The VBA calls the .Net class. The .Net class reads the data and saved into Dataset. The .Net class converts the Dataset into ADODB>Recordset convertible XML string. The VBA code receives the string and loads in to XML document. The Recordset opens the XML document as Reportset.

This system is using around 30 different Excel reports for various purposes. Only one report is giving Out of memory error.

The system is having enough memory.2GB RAM, and having enough virtual memory also.

This record set contains around 30 columns and 7000 rows.

In early the data access method in VB6.0. That is working fine. But we are migrating that data access class from VB6.0 to .Net

Excel version is 2010