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

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" <(E-Mail Removed)> wrote in message
news:b3b5055b-0b9b-4364-ae5a-(E-Mail Removed)...
> 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

Hi, Jim,

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

Best Regards

Sergio

On 24 Nov, 19:43, "Jim Rech" <n...@abc.com> wrote:
> 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" <deltaquat...@gmail.com> wrote in message
>
> news:b3b5055b-0b9b-4364-ae5a-(E-Mail Removed)...
>
> > 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