Differences VBA 2003 - 2007 - 2010

[ErikJan]

This is what I got from Microsoft -doesn't help me very much but I'll share anyway-

Erik Jan,

I located the following two sites which I believe best describe the Object Model changes between MS Office Excel 2007 as compared to MS Office 2003:
1. The following site provides the Status changes between objects changed from 2003 to 2007: http://msdn.microsoft.com/en-us/library/bb242669.aspx" onclick="window.open(this.href);return false;
2. This site has a brilliant method to display the similar changes between the 2003 and 2007 versions, and may also work in the 2010 version as well:
http://excel.tips.net/T006767_Excel_200 ... ences.html" onclick="window.open(this.href);return false;
(Per the site) The easiest way to find this information is to follow these steps in Excel 2007:
> 1. Press Alt+F11 to display the VBA Editor.
> 2. Press F1. The VBA Help system starts.
> 3. Click What's New.
> 4. Click Object Model Changes Since Microsoft Office 2003. (You could click one of the other options to see changes since earlier versions, if desired.)

Finally, the following site details the Object Model changes between MS Office Excel versions 2007-2010, and versions 2003-2010: http://msdn.microsoft.com/en-us/library/ee836187.aspx" onclick="window.open(this.href);return false;

I hope the above sites are found to be useful, though please let me know if you have further questions or concerns related to the changes between the 2003, 2007, and 2010 versions. I will be happy to help as needed to ensure that you have the proper info!

[HiTechCoach]

What are you seeking?

Boyd Trimmell aha HiTechCoch ( http://hitechcoach.com" onclick="window.open(this.href);return false; )
Microsoft MVP

[HansV]

ErikJan has posted a series of questions about VBA code that worked in Excel 2003 but that is causing errors in Excel 2007/2010:
font.background in Excel2007
Programming a Chart and VBA 2003, 2007 and 2010
More Chart VBA mysteries 2003 > 2007

[HiTechCoach]

Thanks Hans.

[ErikJan]

I'm still in contact with MS and they are researching to get a more complete picture on differences between VBA 2003 and VBA2007 AND between VBA2007 and VBA2010.
I noticed some differences between 2007 and 2010, they are surprised and are looking for more data.

In general; can you let me know some things that

(A) worked in 2003 and no longer work in 2007 (I know about Application.FileSearch )

(B) worked in 2007 and no longer work in 2010

I will then try to forward this to MS

[HiTechCoach]

Are you interesting in Excel only or all the Office suite apps?

[ErikJan]

Oh, yes, I didn't think about that. My focus is Excel here, maybe we should try to stick to that for now?

[Jim Cone]

I tried the tech release of xl2010, but currently don't have xl2010 installed.

For what it is worth...
In the xl2010 tech release I found that using the .BorderAround method resulted in partial borders or no borders being applied.
Also...
In public.excel.programming 05/31/2010, "Sebastien" reported that...
In xl 2010, when you add a shape to a sheet, TypeName(ActiveSheet.Shapes(1).TopLeftCell.Parent) returns "Shape",
while in other versions of excel, you get "Worksheet"
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2" onclick="window.open(this.href);return false; (Dropbox)

[Becks]

One of my grievances was that Application.Caller() behaved differently from 2003 to 2007. I assume that it is the same in 2010 as for 2007.


Regards
Kevin

[rory]

In what way?

[Becks]

In V2003, i could use the following code snippet to find out which menu item or sub-item had been selected for my menu

menu.JPG

Code: Select all

:
    c = Application.Caller()
    If c(4) = 0 Then
        Select Case c(1)
            Case 1
:
        End Select
    ElseIf c(4) = 11 Then
        Select Case c(1)
            Case 1
:

While the code still works for the menu items, it fails for the sub-menu items - c(4) always returns 0

Regards
Kevin

[rory]

Ah, I've always used ActionControl for CommandBars since, as far as I know, Application.Caller hasn't been officially support/documented for commandbars for a long time.

[ErikJan]

For the record: I have some contacts with MicroSoft. To date, these contacts have been more than excellent. I have (and will) forward links and concerns I stumble upon and all of you report here every once on a while (no promises...). Obviously, that's all I can do: I have no connections to MS and therefore they do not have a formal obligation to do anything with the info I send them. I did sense a willingness to listen and internally address issues however so who knows if and how some stuff will be addressed in future MSO releases...

[ErikJan]

Ah, I've always used ActionControl for CommandBars since, as far as I know, Application.Caller hasn't been officially support/documented for commandbars for a long time.

Do we know if this is still misbehaving in VBA/Excel 2010?

[ErikJan]

I learned from MS that -as I found out the hard way- the macro recorder in 2007 is flawed; specifically for the Chart Object elements. See also http://support.microsoft.com/default.as ... -US;937620