Differences among VBA in Excel 2007 and 2010

[deltaquattro]

Hi,

as per object, do you know which are the main differences, if any?
AFAIK, for Excel 2000 vs Excel 2007 the differences are due to the
fact that the Excel object model is (slightly) changed. For example,
now embedded Charts are in the Shapes collection, and even this
doesn't make that big of a difference, since at the same time they
remain also in the ChartObjects collection (for backward
compatibility, I suppose). But what about Excel 2007 and 2010? My
company is switching to 2010: I bought a book for programming with
2007, and I'm really not buying another one if, VBA-wise, differences
are insignificant. Thanks,

Best Regards

Sergio

 

[Jim Rech]

Not much has changed. As usual most of the additions are related to new
Excel features like slicers. Once you install Excel 2010 look at What's New
in VBE help. That should be all you need.

 

[deltaquattro]

Hi, Jim,

thank you very much for the info, I'll stick to my new, shiny Excel
2007 book then

Best Regards

Sergio