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.
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.