ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clearing Memory (https://www.excelbanter.com/excel-programming/356139-clearing-memory.html)

[email protected]

Clearing Memory
 
I wrote a maco that will process 14 different spreadsheets. It will
automaticlly bring in a spreadsheet process it, write it out, and get
the next one to process. These are very big spreadsheets like over
30,000 rows each. The first one takes about 25 mins to process then
the next an hour until after about 5 times its up to 3 to 3 1/2 hours.
Is there a way to clear memory between each loop.
Thanks


[email protected]

Clearing Memory
 
Thanks Kim; I will give this a try and let you know.



All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com