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.

Are you using pagesetup each time. Perhaps this:

http://support.microsoft.com/default...69&Product=xlw
OFF: PageSetup Object Causes Memory Leak and Hangs System

--
Regards,
Tom Ogilvy


"Chris K." wrote in message
om...
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.

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Chris K." wrote in message
om...
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.