Excel called from external app (OLE) stops after processing exactly 10921 rows
How about using ADO and SQL to manipulate your Excel data?
--
"Peter Gloor" wrote in message ...
Just an update:
I'm out of ideas. It performs about the same for row 2 to row 10921. I
can't
see any performance degradation. The system monitor shows 100% CPU, but no
remarkable changes in memory usage. The resource display show 62% free for
user and system resourcs and 86% free for GDI resources.
Sorry, the information about free resources is wrong. The actual values a
47% free user and system resources
71% free GDI resources.
In addition the System monitor shows a peak with disk write (and some read)
activity just before the system hangs.
I tried to split the range into subranges (each 1000 rows). No change.
Hangs
after 10901 rows have been processed. I'll try this again with some kind
of
wait in between, to make sure Excel can follow and gets enough time to
cleanup resources.
The implementation of a Wait (Application.Wait) for one second each 1000
rows didn't help either.
Peter
|