Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open / Close Workbook Memory issue
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I close only 1 workbook when I have many open? | Excel Discussion (Misc queries) | |||
Open, print and close workbook | Excel Programming | |||
Open, print and close workbook | Excel Programming | |||
Close Open Workbook | Excel Programming | |||
Close Open Workbook | Excel Programming |