View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helge's Helge's is offline
external usenet poster
 
Posts: 16
Default 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