Expose a Referenced Class to Excel VBA from a vb.net com class.

M

Marion Pope

New member
Joined
Dec 9, 2003
Messages
2
I created a vb.net com interop class called MatrixExcelInterop which uses a reference to a ematrixClientXML.dll which is supplied by a third party. I have written my own functions in the com interop class using the classes in the ematrixClientXML.dll . In excel 2000 vba, I reference to the MatrixExcelInterop and the functions that I wrote are exposed and work ok. The classes from the ematrixClientXML.dll reference are not exposed. I would like to just write my code in VBA. I tried to reference ematrixClientXML.dll directly in VBA by browsing and I get a "Cant add a reference to the specified file" error. I am novice in vb.net, is there a way that these classes can be exposed to VBA.

Thanks in advance for your reply,
Marion
 
Back
Top