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
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