Return Array from .net Interop Class to Excel VBA Error

Marion Pope

New member
Joined
Dec 9, 2003
Messages
2
I used the walkthrough to create a Com object in VB.net and wrote a class with a function that returns an array.

When I reference the dll in Excel VBA and call the class function I get the "Sorry for the Inconvenience" from Microsoft and it shuts down excel no matter what size or shape of the array. The help on the error is " The instruction at "0x6521a9b3" referenced memory at "0x006f004b". The memory could not be "read". " Tried rebooting, the whole bit. The error is consistent.

I changed the function to return a Collection and I get the error on VB.net Build Solution erro: "Com Interop registration failed - could not find a type library for the assembly Microsoft.VisualBasic." Microsoft.Visual Basic seems to be ok.

Returning an ArrayList from the works fine and is exposed to Excel VBA.

Any ideas on how to correct the array problem will be greatly appreciated.

Thanks in advance for you help,

Marion Pope
 
Back
Top