Not enough system resources

[akabraha]

I have a macro which pulls data from a server, uses dynamic array, many variables, calculations etc. I don't get any run time error, but at the end of the macro - I get the following error/message with the result.

"Not enough system resources to display completely"

I am not sure how to fix this. Any ideas?

Thanks in advance,
Anil

[protonLeah]

So! Where's the code?

[Leith Ross]

Hello Anil,

System resources are small fixed memory areas used by the Windows 9.x operating systems. There are 2 types of system resources: User and GDI (Graphic Driver Interface). The User component manages input from the keyboard, mouse, and other input devices and output to the user interface (windows, icons, menus, and so on). It also manages interaction with the sound driver, timer, and communications ports.

The Graphics Device Interface (GDI) is the graphical system that manages what appears on the screen. It also provides graphics support for printers and other output devices. It draws graphic primitives, manipulates bitmaps, and interacts with device-independent graphics drivers, including those for display and printer output device drivers. Both of these are limited to 64 KB of memory and cannot be increased.

As you can see, there may be many things you can do with your program or system to reduce the resources used. Of course, if you could run all your code on newer system then all your problems would be solved.

Sincerely,
Leith Ross

[akabraha]

Thanks a lot, understood what you were saying eventhough it's kind of greek to me. As you mentioned, I didn't get any error when I ran on a different system - I was thinking that I am using many variables and they are not getting released after use causing not enough system resources.]

Thanks, Anil