Excel 2007 VBA Differences

Deon wonders if anyone has compiled a list of differences between Excel 2003 VBA and Excel 2007 VBA. Such a list would be very helpful as he is working on updating older macros to work with the latest version of Excel.

The easiest way to find this information is to follow these steps in Excel 2007:

1. Press Alt+F11 to display the VBA Editor.
2. Press F1. The VBA Help system starts. (Click here to see a related figure.)
3. Click What's New.
4. Click Object Model Changes Since Microsoft Office 2003. (You could click one of the other options to see changes since earlier versions, if desired.)

At this point you can browse through the available options to see what has changed. If you prefer to access the same information in a browser window instead of in the Help system, simply visit this page:

http://msdn.microsoft.com/en-us/library/bb242669.aspx

The number of changes from VBA in Excel 2003 to VBA in Excel 2007 is not great. But it is important to remember that the limits of the program itself are greatly expanded. For instance, if your old macros only checked for data in 65,536 rows, the number of rows in Excel 2007 has greatly increased. If your macro was written to old limits, you'll want to check to make sure it adjusts properly to the expanded limits.