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!
Differences VBA 2003 - 2007 - 2010
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Differences VBA 2003 - 2007 - 2010
This is what I got from Microsoft -doesn't help me very much but I'll share anyway-
-
- NewLounger
- Posts: 13
- Joined: 16 Sep 2011, 18:08
Re: Differences VBA 2003 - 2007 - 2010
What are you seeking?
Boyd Trimmell aha HiTechCoch ( http://hitechcoach.com" onclick="window.open(this.href);return false; )
Microsoft MVP
Boyd Trimmell aha HiTechCoch ( http://hitechcoach.com" onclick="window.open(this.href);return false; )
Microsoft MVP
Boyd Trimmell, Microsoft MVP - Access Expert
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Differences VBA 2003 - 2007 - 2010
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
font.background in Excel2007
Programming a Chart and VBA 2003, 2007 and 2010
More Chart VBA mysteries 2003 > 2007
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 13
- Joined: 16 Sep 2011, 18:08
Re: Differences VBA 2003 - 2007 - 2010
Thanks Hans.
Boyd Trimmell, Microsoft MVP - Access Expert
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Differences VBA 2003 - 2007 - 2010
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
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
-
- NewLounger
- Posts: 13
- Joined: 16 Sep 2011, 18:08
Re: Differences VBA 2003 - 2007 - 2010
Are you interesting in Excel only or all the Office suite apps?
Boyd Trimmell, Microsoft MVP - Access Expert
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
aka HiTechCoach
http://www.hitechcoach.com" onclick="window.open(this.href);return false;
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Differences VBA 2003 - 2007 - 2010
Oh, yes, I didn't think about that. My focus is Excel here, maybe we should try to stick to that for now?
-
- StarLounger
- Posts: 78
- Joined: 18 Feb 2010, 01:44
Re: Differences VBA 2003 - 2007 - 2010
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)
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)
Last edited by Jim Cone on 14 Oct 2016, 13:33, edited 1 time in total.
-
- 2StarLounger
- Posts: 196
- Joined: 31 Mar 2011, 03:41
- Location: Perth, Western Australia
Re: Differences VBA 2003 - 2007 - 2010
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
Regards
Kevin
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
-
- 2StarLounger
- Posts: 196
- Joined: 31 Mar 2011, 03:41
- Location: Perth, Western Australia
Re: Differences VBA 2003 - 2007 - 2010
In V2003, i could use the following code snippet to find out which menu item or sub-item had been selected for my menu
While the code still works for the menu items, it fails for the sub-menu items - c(4) always returns 0
Regards
Kevin
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
:
Regards
Kevin
You do not have the required permissions to view the files attached to this post.
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Differences VBA 2003 - 2007 - 2010
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.
Regards,
Rory
Rory
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Differences VBA 2003 - 2007 - 2010
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...
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Differences VBA 2003 - 2007 - 2010
Do we know if this is still misbehaving in VBA/Excel 2010?rory wrote: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.
-
- BronzeLounger
- Posts: 1266
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Differences VBA 2003 - 2007 - 2010
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