Changes to Excel 2007 VBA

[Harry]

I am compiling a summary sheet of changes to Excel VBA in Excel 2007 .
I've come across the post with the subject "Excel 2007 VBA versus excel
2003" and wondered if there were any other major points that needed to be
covered.

Example: the autoFilterMode property now works with worksheets. Each table
object has its' own AutoFilter object.

thanks,
Harry

 

[Jayson Wiser]

Some things I have run into:
-The calculation structure seems to have changed, so previously fast code
could run slower.
-All Chart code must be redone.

 

[Jon Peltier]

Also:
- Shapes have a different object model.
- Formatting colors has changed considerably.
- Pivot tables have changed.
- 2003 List upgraded to 2007 Tables.
- Conditional Formatting.

Expanding on Jayson's post:
- Charting does not need to be completely redone. However, the custom
built-in chart types are gone from the UI and do not work reliably in VBA.
The chart elements behave like the new shapes, so formatting is a total
bear. Also, some things which used to work, and documentation gives no
indication of changes, have changed, and you need to tweak the code, change
the order of commands, include formerly optional arguments, etc.

Plenty of work for us developers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______