MS Office VBA changes from 2003 to 2010

3
votes

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.

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.

Thanks a lot for your help!

1
excelms-accessvbams-office
For the most part, 32 bit Access 2003 mdb should work quite well in MS Access 2010, there is no need to convert to accdb for existing applications. What are some of the problems? – Fionnuala
The primary issues I encountered when upgrading was that I had foolishly done early binding. Perhaps the majority of your problems would be solved with late-binding? – Daniel
There are some things you should be aware of if your using 64bit office 2k10; msdn.microsoft.com/en-us/library/… – Alex K.
Be aware that any missing references will cause strange behaviour including built-in keywords not being recognised. A quick check of the references dialog will show if any references are marked as "MISSING:" – barrowc

1 Answers

9
votes

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.

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: