VBA changes Excel 2002 -> Excel 2007
excel, migration, vba
Solution
- Open Excel 2007 and go into the VBA editor (Alt+F11)
- Open up Help (F1)
- Click What's New
- 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.
Problem
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?