VBA中的XLA到VSTO中的DLL [英] XLA in VBA to DLL in VSTO
问题描述
Hello
我尝试在C#中开发一些Excel插件。我有XLA插件(你在VBE中编写的VBA标准excel插件),我希望他们使用C#而不是VBA。
为实现这一目标,我尝试了Visual Studio可扩展性/共享插件项目,并通过基本的COM插件直接攻击OfficeXP PIA。但它并不令人满意,因为所有这些都是旧技术并且缺乏很多功能。
然后我安装了VSTO 2005 SE(微软下载网站上的轻量版)在Visual Studio Professional 2005之上。我尝试在C#for Excel 2003中开发一些excel插件(以替换我的VBA XLA插件)。
< p align = left>
我希望我的C#addins能够:
- 公开函数/ subs可通过Excel 2003单元格和控件(按钮,...)
- 公开通过我的excel 2003 XLS文件的VBA调用可访问的函数/子和类/对象
- 能够从C#中捕获事件并修改我的菜单,工具栏,...来自C#
- 能够将其移植到Office 2007稍后
- 了解最新的VSTO版本
我试过Visual Stud io 2008 Team Suite试用版没有取得更多成功。我开始使用电动工具,但仍无法完成我的尝试。
I使用VSTO 2005 SE为Excel 2003创建了ExcelAddin。但我无法从单元格或VBA代码访问我的方法。
没人知道?
Hello
I try to develop some Excel addins in C#. I had XLA addins (the standard excel addins in VBA that you code in VBE) and I'd like them to be in C# instead of VBA.
To achieve that, I tried to do Visual Studio Extensibility/Shared Addin projects and directly attack the OfficeXP PIA through a basic COM addin. But it's not satisfying enough because all these are old technologies and lack a lot of functionnalities.
Then I installed VSTO 2005 SE (the light edition avaible from microsoft download website) on top of Visual Studio Professional 2005. I tried to develop some excel addins in C# for Excel 2003 (to replace my VBA XLA addins).
I want my C# addins to be able to:
- expose functions/subs accessible through Excel 2003 cells and controls (buttons, ...)
- expose functions/subs and classes/objects accessible through VBA calls from my excel 2003 XLS files
- being able to catch events from C# and modify my menus, toolbars, ... from C#
- being able to port that to Office 2007 later
- keep up with latest VSTO releases
I tried Visual Studio 2008 Team Suite Trial without more success. I began to use the power tools but still can't manage to do what I try to do.
I created an ExcelAddin with VSTO 2005 SE for Excel 2003. But I can't access my methods from cells nor from the VBA code.
No one knows?
这篇关于VBA中的XLA到VSTO中的DLL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!