Accessing a VSTO application-addin types from VBA (Excel)

Posted by Kang Su on Stack Overflow See other posts from Stack Overflow or by Kang Su
Published on 2009-09-24T21:17:58Z Indexed on 2010/04/03 2:13 UTC
Read the original article Hit count: 485

Filed under:
|
|
|
|

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!

© Stack Overflow or respective owner

Related posts about excel

Related posts about vsto