Question Invoking a VB.net class from Excel 2007 VBA code

Keith Howard

Active member
Joined
Jan 28, 2010
Messages
28
Programming Experience
5-10
Hello,

We have an Excel 2007 workbook containing VBA code. We need to call a VB.net Shared Add-In project dll Class from Excel VBA code.

We tried to include a reference to the dll as an Add-In using Excel->Option->Add-Ins-> Manage-> Excel Add-Ins but it gave error message saying "dll in not a valid add-in".

We also checked avalaible references within Shared Add-Ins in ExcelVBA->Tool->Reference-> Available reference of add-In but we are unable to find any refrence to our VB.net dll (which we had built and installed properly).

We tried building the VB.net project in Debug as well as Release modes.
Thank you for any help in resolving this issue.

Regards,

Keith
 
Top Bottom