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.
