Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Differences among VBA in Excel 2007 and 2010

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Differences among VBA in Excel 2007 and 2010

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" wrote in message
...
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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Differences among VBA in Excel 2007 and 2010

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" 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" wrote in message

...

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solution for Application.FileSearch Excel 2007-2010 Michel Demers[_2_] Excel Programming 2 November 23rd 10 12:28 AM
Differences between VBA in Excel 2007-2010 Tara H Excel Programming 2 May 18th 10 06:01 PM
Set color for chart serie in excel 2007/2010 Lina Excel Programming 5 May 6th 10 05:35 PM
Differences Between Excel 2007 Versions Karin Excel Programming 5 September 23rd 09 01:51 PM
Excel 2007 version differences [email protected] Excel Discussion (Misc queries) 2 April 27th 07 01:01 AM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"