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
_______
"Jayson Wiser" <jayson.wiser+MS-Excel-(E-Mail Removed)> wrote in
message news:F4695068-B9CF-4AA6-8DF8-(E-Mail Removed)...
> 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.
>
> "Harry" wrote:
>
>> 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
Similar Threads
