Does Microsoft Office 2016 support VBA on OS X?

Targets macOS
1

Microsoft Office 2016 was just released today with new additions to Office. One of the interesting parts seems to be that Microsoft is building the VBA editor for Mac from scratch. Here is a snippet of the article:

[quote]Mac Office 2016 VBA

This is the painful one. Mac Office 2016 does still support VBA, of course, and Microsoft has rebuilt the VBA Editor from scratch, which was drastically. Unfortunately the VBA Editor is not really ready to use: you can’t insert new modules or UserForms, and while you can edit existing modules, you can’t even view the UserForms.
Microsoft is making small improvements to the VB editor, and these improvements will be part of the monthly updates. but they are not expecting to make the editor as functional as that in Windows. They encourage developers to build their add-ins in Windows versions of Excel or in Excel 2011, then test in Mac Excel 2016.[/quote]

Although VBA for Mac may not be fully functional yet, it looks like we may be able to have Xojo interface with Microsoft Office on both Windows and OS X operating systems.

I hope this is true!

2

What remains to be seen is whether they have an API that can be used to control it
Old versions (like 2004 ish maybe earlier) did
Then they got away from providing any kind of SDK for third parties
So on OS X you only had AppleScript as an option
Not that it was bad it was just not straight forward for any third parties to write apps that controlled excel etc

3

The VBA editor in Windows hasn’t been updated in 10 years or so. Still, something is better than nothing.

The article you mentioned says:

Strange. This white in white in white design always makes me think of kindergarden. Skype in particular looks ridiculous.

Wasn’t Office 2016 for the Mac supposed to be released in a full version this month? Don’t really want to do Office 365.

4

It will be released today :slight_smile:

http://www.microsoftstore.com/store/msde/de_DE/pdp/Office-Home-amp-Business-2016-fur-Mac/productID.324399800?ICID=Office_Mac_ModE_HB16Mac

5

@Sascha: thanks for the info. The articles above were older.

Microsoft really wants you to use that Office 365. The license is for ONE Mac.

6

I found this.
http://peltiertech.com/office-2016-for-mac-is-here

[quote]Mac Office 2016 VBA
This is the painful one. Mac Office 2016 does still support VBA, of course, and Microsoft has rebuilt the VBA Editor from scratch, which was drastically. Unfortunately the VBA Editor is not really ready to use: you can’t insert new modules or UserForms, and while you can edit existing modules, you can’t even view the UserForms.
Microsoft is making small improvements to the VB editor, and these improvements will be part of the monthly updates. but they are not expecting to make the editor as functional as that in Windows. They encourage developers to build their add-ins in Windows versions of Excel or in Excel 2011, then test in Mac Excel 2016.
[/quote]