General discussion

Locked

MS Access97 - Excel 97, Out of memory

By ladufresne@.up.com ·
I update Excel pivot reports from Access 97. A table in Access stores the Excel XLS files to be updated. VBA code opens an Excel workbook from the Access table list, runs a refresh macro on each pivot table in the Excel workbook, saves and closes the workbook (but not Excel, returns to Access for the next Worksheet to open and update.
This works fine for about the first 7 or 8 workbooks in the list and then I receive an "out of memory" message generated from Excel.
Any ideas on how to rectify this error message so that I can continue processing the remaining workbooks in the list.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MS Access97 - Excel 97, Out of memory

by DKlippert In reply to MS Access97 - Excel 97, O ...

Here are a couple of KB articles that appear to relate to this problem. Perhaps closing Excel and reopening may be necessary to realy flush the cache.
http://support.microsoft.com/support/kb/articles/Q104/3/08.asp
http://support.microsoft.com/support/kb/articles/Q129/1/60.asp

Collapse -

MS Access97 - Excel 97, Out of memory

by ladufresne@.up.com In reply to MS Access97 - Excel 97, O ...

The question was auto-closed by TechRepublic

Collapse -

MS Access97 - Excel 97, Out of memory

by donq In reply to MS Access97 - Excel 97, O ...

I absolutely agree with Answer 1. You will need to rework your code (or macro) to save then close each open Excel workbook AND Access recordset after each pair has completed their assigned tasks. You definately have enough memory to support a single iteration if you don't run out of memory until you're working on the 7th or 8th dataset before running out of memory now.

Collapse -

MS Access97 - Excel 97, Out of memory

by ladufresne@.up.com In reply to MS Access97 - Excel 97, O ...

The question was auto-closed by TechRepublic

Collapse -

MS Access97 - Excel 97, Out of memory

by ladufresne@.up.com In reply to MS Access97 - Excel 97, O ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums