Memory problem
 

When running a program with many iterations that creates
183 worksheets and populates them with data obtained from
other workbooks, I get an "Out of Memory" message aftere
about 27 iterations.
Using the Application.MemoryTotal, MemoryUsed, MemoryFree
properties in a sub, I get the following figures:
Total: 2,908,064 bytes
Used: 1,897,064 bytes
Free: 1,048,576 bytes.
What can I do to either use less or create more total
memory? Can I clear memory (using code) after each
iteration? Or maybe through the Windows options?

Lionel

Memory problem
 

do you really need so many worksheets?
Instead of pushing data into a worksheet, save it into a
text file


-----Original Message-----
When running a program with many iterations that creates
183 worksheets and populates them with data obtained
from
other workbooks, I get an "Out of Memory" message aftere
about 27 iterations.
Using the Application.MemoryTotal, MemoryUsed,
MemoryFree
properties in a sub, I get the following figures:
Total: 2,908,064 bytes
Used: 1,897,064 bytes
Free: 1,048,576 bytes.
What can I do to either use less or create more total
memory? Can I clear memory (using code) after each
iteration? Or maybe through the Windows options?

Lionel

.