VBA differences Excel 2003 and 2007

[ErikJan]

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?

[HansV]

A rather dry overview can be found by clicking the links in What's New.

[ErikJan]

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...

[HansV]

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.)

[Jan Karel Pieterse]

No language changes indeed, just changes in the object model.
Excel 2010 does have language changes however, due to the new 64 bit support.

[ErikJan]

Interesting... I have Win7 64but... so Office 2010 will support 64 bit then?

[HansV]

Yes, Office 2010 will be available in 32-bits and 64-bits versions.

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.

From: Getting started with the deployment of Office 2010.

[Jan Karel Pieterse]

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

[Wendell]

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.