VBA differences Excel 2003 and 2007
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
VBA differences Excel 2003 and 2007
Last one today (I hope); is there a place where I can find the differences in VBA between Excel 2003 and 2007. I understand that most involve the GUI changes, I'm specifically interested in VBA coding changes/improvements.. anayone?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA differences Excel 2003 and 2007
A rather dry overview can be found by clicking the links in What's New.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: VBA differences Excel 2003 and 2007
So, I see no language changes... correct?
I recall that 2003 had e.g. the INSTRREV (or something similar, doing this from memory) which would find a character starting at the end of a string. Plus a couple more...
I recall that 2003 had e.g. the INSTRREV (or something similar, doing this from memory) which would find a character starting at the end of a string. Plus a couple more...
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA differences Excel 2003 and 2007
InstrRev was introduced in VBA for Office 2000, together with a bunch of other functions such as Replace, Round, Split and Join. Since then, the Visual Basic language itself hasn't been updated as far as I know. The only changes are in the object model for each individual application (Word, Excel, Access etc.)
Best wishes,
Hans
Hans
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: VBA differences Excel 2003 and 2007
No language changes indeed, just changes in the object model.
Excel 2010 does have language changes however, due to the new 64 bit support.
Excel 2010 does have language changes however, due to the new 64 bit support.
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: VBA differences Excel 2003 and 2007
Interesting... I have Win7 64but... so Office 2010 will support 64 bit then?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA differences Excel 2003 and 2007
Yes, Office 2010 will be available in 32-bits and 64-bits versions.
From: Getting started with the deployment of Office 2010.Office 2010 introduces native 64-bit versions of Office products to take advantage of the additional capacity provided by 64-bit processors. This additional capacity is only needed by Office users who require Excel spreadsheets that are larger than 2 GB, for example.
Best wishes,
Hans
Hans
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: VBA differences Excel 2003 and 2007
Yes it has a 64 bit version. But if you take the defaults during install, it will setup the 32 bit version. To get the 64 bit one, you have to browse to a specific folder on the setup disc.
See this page for some info on 64 bit coding:
http://www.jkp-ads.com/articles/apideclarations.asp
and this one:
http://msdn.microsoft.com/en-us/library ... e.14).aspx
See this page for some info on 64 bit coding:
http://www.jkp-ads.com/articles/apideclarations.asp
and this one:
http://msdn.microsoft.com/en-us/library ... e.14).aspx
-
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: VBA differences Excel 2003 and 2007
I would procede with some caution if you decide to install the 64-bit version of Office 2010 - some significant changes were required to create the 64-bit version as I understand it. Once they release the final version to manufacturing, and especially once they put out SP1, it should be pretty solid.
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!