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