memory leaks

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...

Hi I have an application that will run at a clients site for an indeterminate amount of time, sometimes days, sometimes hours. But at some point it will crash. What I've determined so far, by stepping through the code, is that VBA statements are executing without debugging, but most...

I have developed a pretty large VBA project which started to eat up more and more memory as it runs, so I am interested in finding various methods to stop the flood. Some background info: - the project imports data from a variety of sources: HTML files, Thunderbird local folders, e-mail messages...