Hi,
I am getting the Excel error "Not enough system resources to display
completely" when I use automation to run Excel 2002 SP-2 launched from
Access 2002 SP-2. It is an automated process that kicks off at 4:15am.
I reboot every day before I leave. Excel is not visible. Today had
59 reports. It usually halts the reports around 6:15am when no one is
around to click OK. When Ok is clicked, it continues with no problems.

I use an array to populate the worksheets. This process has been
running daily for years, and this problem just started a month ago,
about a month after converting to XP. The reports that halt are wide
but not long. The widest goes to cell EJ391. Of course the users now
want to add 14 more columns. I put these 4 reports at the end, and it
still halted on smaller reports earlier in the process.

This morning I ran the process on a new machine with 1gig ram, 64mb
video. The zoom is at 100%. Got good info from decisionmodels.com. I
have done defrags, disk cleanup, swapfile size, reduced colors to 16bit
and 800by600. Randomly the Advanced button on the Display Properties
goes dim and I cannot change the screen resolution or colors. This
happened on the old pc and now this new one. We only replaced the box,
not the monitor, key, or mouse. Also, the server that the dbs and xls
are on is about out of room.

I am tired from and tired of getting up with this process just to click
ok!!! Any help would be greatly appreciated!
Thanks,
Kristy