I'm doing a project which requires the opening and closing of a lot of
workbooks and I'm hitting memory problems. Therefore I tried the following
test:
If I declare a workbook as an object, then open it, save it under another
name and close it, set the object to be nothing and then repeat this 500
times, memory usage fluctuates but generally increases. Is there a way to
fully clear the object from memory?
I'm using Excel XP SP-2 on Windows XP.