MS Office VBA从2003年到2010年发生了变化

时间：2021-06-19 11:46:29

in my company the IT-department finally decided to switch from MS Office 2003 to 2010. In my department we developped many small Applications running on VBA. Particularly all of them were programmed in MS Excel and MS Access. Now a few weeks ago we received a PC for testing our Applications -> and of course no Application is really running the way it´s supposed to do.

在我的公司,IT部门最终决定从MS Office 2003切换到2010年。在我的部门,我们开发了许多在VBA上运行的小型应用程序。特别是所有这些都是在MS Excel和MS Access中编程的。几个星期前,我们收到了一台用于测试我们的应用程序的PC - >当然没有应用程序真正按照它应该的方式运行。

So my question is, if there is any source of information which informs about all the changes made from Office 2003 to 2007 and from 2007 to 2010 - especially concerning the VBA syntax and functions. I read something about single changes but couldn´t find a summary.

所以我的问题是,如果有任何信息来源可以告知从Office 2003到2007以及从2007年到2010年所做的所有更改 - 特别是有关VBA语法和功能的更改。我读过有关单个更改的内容,但无法找到摘要。

Thanks a lot for your help!

非常感谢你的帮助!

1 个解决方案

#1

9  

Very little changed within VBA itself. VBA went from version 6 to version 7, but the only real change was the inclusion of support for 64-bit API calls. See What are the differences between VBA 6.0 and VBA 7.0? for more details.

VBA内部变化很小。 VBA从版本6转到版本7,但唯一真正的变化是包含对64位API调用的支持。请参阅VBA 6.0和VBA 7.0之间的区别是什么?更多细节。

However, the libraries (and their associated object models) for Excel, Access, Word, Outlook, etc. will have significant changes. The best resource for what changed in the object models is the official MS Developer Reference for each respective project. Each reference contains a section in the beginning entitled "What's New?"

但是,Excel,Access,Word,Outlook等的库(及其关联的对象模型)将发生重大变化。对象模型中更改的最佳资源是每个相应项目的官方MS Developer Reference。每个参考文献都包含一个标题为“什么是新的?”的部分。

For convenience, I'll provide links to the ones you specifically mentioned:

为方便起见,我将提供您特别提到的链接:

#1

9  

Very little changed within VBA itself. VBA went from version 6 to version 7, but the only real change was the inclusion of support for 64-bit API calls. See What are the differences between VBA 6.0 and VBA 7.0? for more details.

VBA内部变化很小。 VBA从版本6转到版本7,但唯一真正的变化是包含对64位API调用的支持。请参阅VBA 6.0和VBA 7.0之间的区别是什么?更多细节。

However, the libraries (and their associated object models) for Excel, Access, Word, Outlook, etc. will have significant changes. The best resource for what changed in the object models is the official MS Developer Reference for each respective project. Each reference contains a section in the beginning entitled "What's New?"

但是,Excel,Access,Word,Outlook等的库(及其关联的对象模型)将发生重大变化。对象模型中更改的最佳资源是每个相应项目的官方MS Developer Reference。每个参考文献都包含一个标题为“什么是新的?”的部分。

For convenience, I'll provide links to the ones you specifically mentioned:

为方便起见,我将提供您特别提到的链接:

标签：

相关文章