Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Out of memory error
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 "NickHK" wrote: 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" '''' wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle error 8007000e Memory Error | Excel Programming | |||
Out of Memory Error 7 | Excel Programming | |||
Out of memory error | Excel Programming | |||
Out of Memory error | Excel Programming | |||
Out of memory error. | Excel Programming |