Newbie: HRESULT 0x800A03EC , OLE exception

[steve]

Hi,

I managed to copy asome datagrid information and paste it to Excel using
Arrays.
The problem (Exception) arises for really big ( > 30000 rows) Tables. Is
this an Excel limitation or my code raises the exception ?

TIA
-steve

 

[Chris]

Hi,

I managed to copy asome datagrid information and paste it to Excel using
Arrays.
The problem (Exception) arises for really big ( > 30000 rows) Tables. Is
this an Excel limitation or my code raises the exception ?

TIA
-steve

Umm... What's the exception?

Chris

 

[steve]

sorry! Like the Subject line says:

HRESULT 0x800A03EC
couldnt find it on MSDN nor SDK.

I've used the code from MSDN's article 306022. especially the line:

oSheet.Range("A2").Resize(numRows,numColumns).Value=myArray

to transfer the whole array directly.
I tried element by element and (as many people complained on the net) VERY
slow and understandably so : there is a note on the article for the reason.

The FUNNY thing is than when my datagrid is less than approx. 20000 elements
then no problem. If its more then I get the exception.....

TIA