Excel 97 VBA on Win98 Out of Memory Error

C

Chris K.

I am developing an Excel project in VBA Excel 97 on a Windows 98
platform. The project requires that a few thousand labels be printed
daily. Everything prints fine but Windows gives an Out of Memory
Error from Windows, not Excel, after about a thousand labels and the
computer must be shut off and restarted to work again. How I am doing
this is the program reads information from a worksheet in the current
workbook and writes to another worksheet from that. I make 30 labels
11 rows tall each on a worksheet, print them, wait till the printing
is done, clear the sheet, and on to the next thirty. This project
works fine in Windows 2000 on Excel 97 but I need it to work in
Windows 98 on Excel 97, if anyone could give me a clue as to what is
happening in Windows 98 memory management that I should be aware or
can change to get it to stop sucking up so much memory in Windows 98,
please do.
 
H

Harald Staff

Hi

It's not clear to me what this label is. But I've encountered this after repeatingly
creating/deleting "things" from the drawing toolbar, total crash after 200 some rectangles
only in one session. So in those cases re-using objects instead and setting visible
true/false when needed was the only way out. Those things are called "memory leaks" and
there are no workarounds except avoiding situations that make them.
 
Top