Out of memory error

[Robert Mulroney]

I have a workbook that is part of a complex information system using excel
as the front-end. The system has a menu that opens and closes different
reports generated in several different excel files. Different data sources
are used to generate reports in each file, mostly ADO connections.

One particular workbook generates an error when closing and redisplaying the
menu. The error is "Out of memory". The help button tells me this is error 7.
I'm reasonably sure that the error is not generated by the menu code as it
only occurs when closing this one file. As the help file suggested I’ve run
through the VBA code and eliminated as many public variables as possible but
the error still occurs.

What is this error and more importantly how do I suppress it?

I’ve spent some time adding exaggerated error checking to my VBA code but as
this isn’t a VBA error I don’t think it’s going to help.

- Rm

 

[NickHK]

Robert,
Don't know exactly what you are doing, but there is also the
Excel.OLEDBErrors
and the various Errors collections on the OLEDB object.

Are you querying with ADO on workbooks that are open ?

NickHK

 

[Robert Mulroney]

I'm querying several different data sources to create one centeralised point
for financial reporting and simply displaying the information in excel. We
have diffrent financial systems at different sites all with databases
schemas. My system provides identially formated, recooncilled reports from
the different data sources. The Excel file inquestion just contains VBA code
to execute the queries (ADO mostly) and dispay information.

I'll look into OLE errors, thanks. It does appear to be an excel error
prompt though.

- Rm