VBA version 7?

Any one else noticed this?

VBAversion7

Thats a Major revision number, that should mean there’s been some significant updates should it not? Anyone seen any, I’ve haven’t!

Comments

  1. Daniel says:

    Hi Ross,

    I did notice it. Haven’t noticed any changes though. Been developping my addin on Excel 2010/VBA 7.0 for about two weeks now, and I’m still waiting for the revelation of what has changed between VBA 6 and 7.

    Daniel

  2. JP says:

    There’s also the Office 2010 VBA code compatibility inspector (see http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=23c8a7f6-88b3-48ef-9710-9742340562c0), the likes of which I’ve never seen before.

  3. ross says:

    64 bit of course! Oh that could be fun, I think that deserves a post!
    ps try these links floks:

    info
    tool

    Thanks JP ;-)

  4. Gordon says:

    A bit more info here:

    http://msdn.microsoft.com/en-us/library/ee691831(office.14,loband).aspx

    Particularly the section titled “Introducing the VBA 7 Code Base” – it seems the changes to the object model may be limited to two new constants.

    We sure live in exciting times!

  5. jeng02 says:

    It also looks like the AddressOf statement doesn’t work any more. I guess to prevent hooking into the Windows API.

  6. Laurent says:

    Hello !

    We are waitting the VBA 7.0 SDK !
    Microsoft says, it doesn’t want propose this version to their customers !!

    VSTA for the customers and VBA for office !

    But all users are waitting for a VBA 64 bits !

  7. PicoCAD says:

    I want VBA for my Autocad applications. .Net is most difficult.

Submit a Comment