471,624 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,624 software developers and data experts.

ComException error filling excel range with values

Working with a Shared Addin (Autodual Class implementing the
IdExtensibility2 interface), I'm just makin test in order to fill a
range with values but get ComException Error when trying to set the
result. ("Exception from HRESULT: 0x800A03EC.")

Can someone tell me what I'm doing wrong ?
Thks for help.
Dim numberOfRows As Integer = 10
Dim numberOfColumns As Integer = 10
Dim theValues(10, 10) As Object
For i As Integer = 0 To i < numberOfRows
For j As Integer = 0 To j < numberOfColumns
theValues(i, j) = i * j
oExcel = CType(applicationObject, Excel.Application)
Dim theRange As Excel.Range = oExcel.Range("A1", "J10")
theRange.Value2 = theValues <- HERE IS THE ERROR
Catch ex As Exception
End Try

Nov 21 '05 #1
0 1006

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
1 post views Thread by Ransom | last post: by
reply views Thread by zfraile | last post: by
3 posts views Thread by toffee | last post: by
reply views Thread by leo001 | last post: by
1 post views Thread by ZEDKYRIE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.