在VB.NET中编写Excel宏 [英] Writing Excel macros in VB.NET

问题描述

亲爱的所有人，

我正在使用Excel 2003为应用程序编写Excel宏.
我可以看到代码窗口仅支持VB6编码样式.

有什么办法可以在该Excel宏中用VB.NET编写代码吗?
如果您有任何建议，请告诉我.

谢谢与问候，
M. Gangadhar.

Dear all,

I am writing Excel macros for an application using Excel 2003.
I could see the code window supports only VB6 coding styles.

Is there any way to write the code in VB.NET within that Excel macro?
Please let me know if you have any suggestions.

Thanks & regards,
M. Gangadhar.

推荐答案

是.

伊什.

它使用符合VB.NET的VBA.

您可以编写一个VB.NET函数，然后从宏中调用它.

Yes.

Ish.

It uses VBA, which is VB.NET compliant.

You can write a VB.NET function, and call it from within the macro.

谢谢回复.
您是说我们正在编写VB.Net库(.DLL)，并引用/调用VBA宏中的函数吗?
是否有VB宏的直接代码编辑器窗口可用于VBA宏-或要安装的任何其他实用程序?

致以诚挚的问候，
M. Gangadhar.

Hi,
Thanks for the reply.
Do you mean that we are writing a VB.Net library (.DLL) and referencing/calling the functions inside VBA macro?
Is there direct code editor window for VB.Net available for VBA macro - or any additional utilities to be installed?

With Thanks & Regards,
M. Gangadhar.

这篇关于在VB.NET中编写Excel宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！