go ahead, mac my day

a Macintosh girl in a Microsoft world

Q&A: is Visual Basic returning to Office:Mac?

Q&A: is Visual Basic returning to Office:Mac?

Rate This
  • Comments 11

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.

Comments
  • Good news. I'm sat on my tiny netbook trying to do some excel VBA development now, but I'd rather be doing it upstairs on my nice big iMac.

    When is Office 2011 due then....!?

  • We'll release Office 2011 in time for your holiday shopping pleasure later this year.  :)

  • Will be there an update program for existing 2008 users?

    Thanks.

  • We haven't released pricing details or upgrade options yet.  Those are marketing decisions and not technical ones, so I don't know anything about what goes into that decision-making process.

  • Hi,

    is Arabic and Hebrew language coming to MAC:Office 2011

  • We haven't yet announced the languages that will be supported in Office:Mac 2011.

  • "We're bringing the latest and greatest version of VBA to the Mac, which is 6.5."

    I'm curious why you call VBA 6.5 the latest version of VBA when I've read that VBA 7 has been announced and is coming in Office 2010? Admittedly, I'm unclear if VBA 7 brings anything new to the table over VBA 6.5 other than 64-bit support. Can we imply that Office 2011 won't have 64-bit support unlike Office 2010 on Windows seeing that VBA is only going up to version 6.5?

    In any case, given that previous VBA support in Office for Mac was I believe something like VBA 5 level, a well implemented comprehensive upgrade to VBA 6.5 is most appreciated. Will VBA 6.5 support be implemented across the entire Office 2011 suite in Word, Excel, Powerpoint, and the new Outlook? Hopefully VBA 6.5 in Mac will be as fully featured as the Windows version.

  • Will Outlook:Mac be in the Home and Student Edition? (I hope but I don't think so).

    By the way, how many Office 2011 SKU's (stock- keeping units) or editions will be there?

    (Auto-reply: We haven't yet announced the editions of Office:Mac 2011)

    :-)

  • I forgot to ask, I noticed from the beta and later I've read it on a website that Office 2010 for Windows will use VBA version 7.0, not 6.5 as you said that version (6.5) will be included in Office 2011 for Mac.

    Any differences? Will you include version 7.0 instead of 6.5 and if not, why?

    Thank you!

    If Office 2011 is not yet finalized, update its components, you're still in time.

    :-)

  • We started the VB work quite some time ago.  We started planning to bring VB into what is now Office:Mac 2011 long before we started coding on it.  At that time, VBA 6.5 was the most stable release, and the dates for VBA 7 were unclear.  Today, 6.5 is still the most recent shipping version, and we'll support that.  I don't have anything to share yet with regards to future versions of VBA.

    About SKUs - your auto-reply is right. :)  I'll add in the extra detail that SKU decisions are marketing decisions, not technical ones, which means that it's far outside my domain of expertise (and, to be honest, far outside my area of interest too :).  

  • So VBA will finally be back but will we be able to write VBA macros for Word, Excel and Outlook ?

    On Windows, we can write add-ins to extend Outlook. What is the compatibilty between Windows and Mac OS X for COM add-ins ?

Page 1 of 1 (11 items)