Accessing a VSTO application-addin types from VBA (Excel)
- by Kang Su
We have a VSTO application-addin (not a document-addin) for Excel, and we want to expose an event to VBA code so that the VBA macro can do some action when this event fires in the addin. How can I get the VBA code to be able to subscribe to an event defined in the VSTO application-addin?
I'd think that since the addin is loaded in the Excel process, this shouldn't be too tricky, but haven't found a way yet.
BTW, using VS 2008 and Excel 2007.
Thanks!