Accessing .NET functionality from a macro in a VSTO Excel workbook
- by Daniel DiPaolo
A while back, I built an Excel workbook for someone else using VSTO SE, and there's functionality in the accompanying DLL that they'd like to be able to use in a VB macro in the workbook. Short of rebuilding the workbook with a control that does what they want, is there a way they can just hook into the necessary function somehow via some sort of macro call? Does the macro have any sort of visibility into the functionality within the VSTO-built DLL that is associated with the workbook?