You can run VBA code directly in the Office application itself.
您可以在Office应用程序本身内直接运行VBA代码。
Automation applications are often compiled to native code and therefore execute faster than VBA code.
自动化应用程序经常被编译为本机代码,因此执行速度比VBA代码快。
Keep in mind that hosted VBA code is compiled to p-code, not native code, and this incurs a slight performance penalty, although running in process enables optimized method calls to Office objects.
记住宿主的VBA代码被编译为p代码,而不是本机代码,这会导致性能略微有所下降,尽管在进程内运行能够优化对Office对象的方法调用。
VBA code is never stored as the plain text that you type in to the editor.
VBA代码绝不会作为您输入到编辑器的纯文本存储。
Demonstrates how to call code in a customization assembly from VBA code in the document.
演示如何从文档中的VBA代码中调用自定义项程序集中的代码。
VBA code does not run when the document is in design mode, so you can work on the document and code without running the VBA code.
VBA代码在文档处于设计模式时不会运行,所以您可以处理文档和代码而不会运行 VBA 代码。
VBA code does not run when the document is in design mode, so you can work on the document and code without running the VBA code.
VBA代码在文档处于设计模式时不会运行,所以您可以处理文档和代码而不会运行 VBA 代码。
应用推荐