Excel COM Addin

  • Thread starter Thread starter Jody L. Whitlock
  • Start date Start date
J

Jody L. Whitlock

Developing a COM addin using VB.NET 2003. I am recieving a "Member Not
Found" exception at this code:

Dim Range1 As Range
Dim cell As Range

Range1 = application.Selection

For Each cell In Range1.Cells <--- Exception Thrown
...Code Here
Next

After Googling this to no end, I have not found anything that even
hints to this, except that it is an interop problem. I wish there was
more docs and walk-throughs on how this COM/Excel stuff works. Maybe
something to work on after this works.

Thanks,
Jody W
 
Jody said:
Developing a COM addin using VB.NET 2003. I am recieving a "Member Not
Found" exception at this code:

Dim Range1 As Range
Dim cell As Range

Range1 = application.Selection

For Each cell In Range1.Cells <--- Exception Thrown
...Code Here
Next

After Googling this to no end, I have not found anything that even
hints to this, except that it is an interop problem. I wish there was
more docs and walk-throughs on how this COM/Excel stuff works. Maybe
something to work on after this works.

http://support.microsoft.com/default.aspx?scid=kb;en-us;328347
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982
http://support.microsoft.com/default.aspx?scid=kb;en-us;302094


Armin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top