开发者

Calling VB.NET code from Excel

开发者 https://www.devze.com 2022-12-27 15:28 出处:网络
I open an Excel workbook from VB.Net and then want an event in the workbook 开发者_运维技巧(such as pressing a button) to activate code in VB.Net. How do I accomplish this type of callback?Make the .N

I open an Excel workbook from VB.Net and then want an event in the workbook 开发者_运维技巧(such as pressing a button) to activate code in VB.Net. How do I accomplish this type of callback?


Make the .Net assembly act as a COM object which is quite easy to use from VBA.

See this page for a comprehensive example:
http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/

0

精彩评论

暂无评论...
验证码 换一张
取 消