Posted to microsoft.public.excel.programming

Helge's

external usenet poster

Posts: 16

Automation and lack of resources (error)

Im running a an automation with Excel-VBA where I import 20000 rows
from a database with ADO. Im analysing it in Excel an copying a sheet
with only values to a new book (80 sheets). When its almost finnish I
get an error:

"Can not finnish this task with available resources. Choos less data or
close other programs".

Its not a large book Im copying to and I dont know what to do.

Is it something in VBA I shold do to release resorces?

Helge

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2002 error: cannot complete with available resources when co	lbagwell	Excel Discussion (Misc queries)	0	January 23rd 07 08:26 PM
"Not enough system resources to display correctly" error	hwatari	Charts and Charting in Excel	0	December 18th 04 02:19 AM
combo box error-not enough resources	Brian	Excel Programming	2	October 2nd 03 01:22 AM
Combo Box causes system resources error	Dave[_15_]	Excel Programming	1	July 14th 03 02:17 PM
Combo Box causes system resources error	David Brett	Excel Programming	0	July 14th 03 05:19 AM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us