The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Visual Basic returning to the Mac!

    Discussion in 'Apple and Mac OS X' started by Khris, Mar 2, 2010.

  1. Khris

    Khris Yes I am better than you!

    Reputations:
    655
    Messages:
    2,608
    Likes Received:
    0
    Trophy Points:
    55
    http://blogs.msdn.com/nadyne/archive/2010/03/02/q-a-is-visual-basic-returning-to-office-mac.aspx

    go ahead, mac my day
    a Macintosh girl in a Microsoft world

    Word team blog

    Q&A: is Visual Basic returning to Office:Mac?
    My post about questions we got at Macworld 2010 raised some questions, one of which was this one:

    The biggest question in my mind is: will Office 2011 support visual basic for excel?

    Yes. We announced in 2008 that Visual Basic for Applications will return to the next version of Office (you can read the blog post about it here: saying hello (again) to Visual Basic). And it's still true: Office:Mac 2011 will support VBA.

    We're bringing the latest and greatest version of VBA to the Mac, which is 6.5. We'll still continue to support AppleScript and Automator for your Mac-only scripting needs, and we'll also support VBA for your cross-platform scripting needs.

    For those of you who are interested in getting started with writing Office scripts with AppleScript, I have to recommend Mactech magazine's VBA to AppleScript transition guide. It's 150+ pages of AppleScript goodness, and I've only heard awesome things about it.

    Published Tuesday, March 02, 2010 7:36 AM by nadyne
    Filed under: Office 2011
     
    Khris, Mar 2, 2010
    #1
  2. lokster

    lokster Notebook Deity

    Reputations:
    63
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    55
    that is awesome :D
     
    lokster, Mar 2, 2010
    #2
  3. ltcommander_data

    ltcommander_data Notebook Deity

    Reputations:
    408
    Messages:
    1,398
    Likes Received:
    0
    Trophy Points:
    55
    As the blog post itself mentioned, this has been announced and known since 2008. It is interesting that they say VBA 6.5 is the latest version when VBA 7 is coming with Office 2010. I'm not a heavy VBA user myself, but I believe a common complaint with VBA support in previous versions of Mac Office is that it isn't as complete as VBA on Windows which can lead to problems, although I suppose that can be said for comparisons between Mac Office and Windows Office in general. Hopefully, VBA in Office 2011 will improve things.
     
    ltcommander_data, Mar 3, 2010
    #3