Office 2010 - VBA7 - How Much Diff vs VBA6? 2

[kjv1611]

Can anyone point to a good reference on comparing/contrasting VBA7 to VBA6? Any good info out there? I've done a little bit of looking on the web, nothing in depth, but figured some folks here may very well have dealt with some things already.

I do not suppose I'll be using 2010 at work any time soon, as we have some folks still straggling on getting updated to 2007 as it is. However, I'd like to check into what differences to look forward to, and maybe one day take the time to do some testing on my own at home.

Thanks for any info, references, etc.

 

[PHV]

The main issue is the 64 bit version:

http://msdn.microsoft.com/en-us/library/ee691831.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[strongm]

Essentially, it is the introduction of support for 64-bit platforms. So you get a bunch of (relevant) new data types, and a new winAPI text file that uses them. Oh, and a couple of new conditional compiler constants.

 

[kjv1611]

Thanks for the info, both of you.

strongm,

When you say, "new conditional compiler constants."

Are you talking about the 64-bit and VBA7 or VBA6? I did see a mention of those, saying the 64-bit one would specify whether it was built on 32 or 64-bit platform, and the VBA one would specify whether was built in VBA6 or VBA7.

Or do you mean something else?

Thanks again for the tidbits.

 

[strongm]

They're the ones