Excel range read/write

[Mr O]

Hi,

In VB6 i can use this:
dim aRange() as variant
aRange()=xlapp.range("A1:T25000").value
and read and write 500,000 cells in one single read or write operation.

What is the equivalent to that in vb.net 2010?

tia
O.

olavatwintechdotno

 

[Cor]

Did you try it already with option infer on with

dim aRange =xlapp.range("A1:T25000").value

If it then gives an error put your cursor on xlapp and do Quickwatch, the
complete object is then showed to you.

Success

Cor

"Mr O" wrote in message
Hi,

In VB6 i can use this:
dim aRange() as variant
aRange()=xlapp.range("A1:T25000").value
and read and write 500,000 cells in one single read or write operation.

What is the equivalent to that in vb.net 2010?

tia
O.

olavatwintechdotno