Memory problem

  • Thread starter Thread starter Lionel Fridjhon
  • Start date Start date
L

Lionel Fridjhon

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
 
do you really need so many worksheets?
Instead of pushing data into a worksheet, save it into a
text file
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MemoryFree 4
Not enough memory 4
Maximum Memory Issue Excel 2003 1
Memory Problem 1
Program execution slows down in as iterations increase 6
Out of resources error message - when not... 3
referencing a workbook using string var = error9 1
Memory Leak 1

Back
Top