I have a VBA program that loads a pivot table into a VBA array. The program then creates various spreadsheets required. It opens a new excel file, populates the data, then saves the file and closes the file. The program creates circa 270 excel / CSV files. However, just recently we have run into a memory resource issue as although the excel file is saved an closed there appears to be a residual allocation within the PC's memory. As the program works it way through it eventually fails to save a file because no memory resource is available. "Out of Memory is a generic error and can occur when the machine does not have enough memory to create objects."
This issue has only occurred in the last couple of months and may be due to an excel upgrade?
Any idea how to overcome this issue?
This issue has only occurred in the last couple of months and may be due to an excel upgrade?
Any idea how to overcome this issue?
