VBA changes Excel 2002 -> Excel 2007

Question

Where can I find a complete list of changes in VBA from Excel XP (2002) to Excel 2007? I have a workbook that relies heavily on VBA which I have been working on in 2002, and when I opened it in 2007, I noticed that some things had changed. For instance, my workbook does lots of 3d rotation; I discovered that Shape.ThreeD.RotationX has become Shape.ThreeD.RotationY and vice-versa. I also discovered that I have to negate the rotation values, so that

Shape.ThreeD.RotationX = 90

becomes

Shape.ThreeD.RotationY = -90

I am sure that there are other changes as well, which I have probably missed. I haven't seen the above changes detailed anywhere, so I would like to know:

Which sites detail changes such as the ones I have outline above?

Answer 1

1. Open Excel 2007 and go into the VBA editor (Alt+F11)
2. Open up Help (F1)
3. Click What's New
4. Click Object Model Changes Since Microsoft Office XP (2002)

Voila!

This list is fairly comprehensive as well as interactive, so I won't reproduce it here. But it also has changes since the 97, 2000, and 2003 versions.