[RESOLVED] Fast write to excel, no more working.

[Marraco]

In VB6, this code worked fine, and was the fastest way to write to excel:

Dim MyExcelRange As Excel.Range
	'Code here filling MyExcelRange with data

	'Now, fast copying into excel:
	With MyExcelRange
		MyExcelWorksheet.Range("A1").Resize(.Rows.Count, .Columns.Count) = MyExcelRange
	End With 'MyExcelRange

But now, in VB.NET .Resize() is a read only property, so it no more works.

Is critical to write the data fast, so what is the new fast way to transfer data to excel??
.

[HanneSThEGreaT]

This may help :
http://support.microsoft.com/kb/302094

[Marraco]

This may help :
http://support.microsoft.com/kb/302094

It is. You did it again. Thanks you.

For short, the new right line of code is:

 MyExcelWorksheet.Range("A1").Resize(.Rows.Count, .Columns.Count).Value = MyExcelRange

By the way... ¿how did you find it? I had searched it for hours...
_

[HanneSThEGreaT]

I'm glad that you got it solved!

I don't know, perhaps luck LOL! No, seriouisly, I've got a huge list of resource websites on my PC, which I've compiled over the years, so that made it a little bit easier

Have fun!

[Gizmo001]

Marraco:

How do you assign data to MyExcelRange. Do the data have to come from Excel or can it be dataset or a 2-D array? Thanks.

[Gizmo001]

Please don't reply. HanneSThEGreaT's url provides the info. Thanks, both.