MS Office的VBA改变2003至2010年 [英] MS Office VBA changes from 2003 to 2010

问题描述

在我公司的IT部门终于决定从微软Office 2003切换到2010年。在我的部门，我们developped在VBA运行很多小的应用程序。特别是所有的人都被编在MS Excel和MS Access。 现在，几个星期前，我们收到一台PC来测试我们的应用程序 - >，当然没有应用真正在运行方式it's应该做的事

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.

所以我的问题是，如果有任何信息的来源，通知所有从Office 2003制作，以2007年和2007〜2010年的变化 - 特别是关于VBA的语法和功能。我读了一些关于单一的变化，但couldn't找到一个总结。

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.

非常感谢您的帮助！

推荐答案

很少在VBA本身改变。 VBA从版本6到第7版，但唯一真正的变化是加入了支持64位API调用。请参见什么是VBA 6.0和VBA 7.0之间的区别？了解更多详情。

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.

不过，库（及其相关的对象模型）为Excel，Access中，Word中时，Outlook等都会有显著的变化。在对象模型是什么改变了最好的资源是官方的MS开发人员参考每个相应的项目。每个参考包含在题为开始一段最新消息？

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?"

为了方便起见，我将提供链接，您特别提到了的：

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

• Excel 2007中 - 什么新功能
• Excel 2010中 - 什么新功能
• Access 2007年 - 最新 <？ / LI>
• 访问2010 - 最新 <？ / LI>

• Excel 2007 - What's New?
• Excel 2010 - What's New?
• Access 2007 - What's New?
• Access 2010 - What's New?

这篇关于MS Office的VBA改变2003至2010年的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！