MS Office VBA 从 2003 年到 2010 年的变化
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14144111/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MS Office VBA changes from 2003 to 2010
提问by Tobi89
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!
非常感谢你的帮助！
回答by mwolfe02
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 开发人员参考。每个参考文献的开头都包含一个标题为“What's New?”的部分。
For convenience, I'll provide links to the ones you specifically mentioned:
为方便起见，我将提供您特别提到的链接：
