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
|