After reading all the great things about Microsoft Excel for Mac 2011 that were written before its release, I decided to purchase a copy. My primary goal was to have an Excel version on my MacBook Pro that allowed VBA macros, however the full Office software suite seemed to be a really great value. This includes updating the core VBA engine in Office 2011 to VBA version 6.5, and adding some commands (FormatCurrency, FormatNumber, Replace) that had been disabled in Excel 2004 for the Mac.
![Excel 2011 for mac vba macro moving data Excel 2011 for mac vba macro moving data](/uploads/1/2/5/7/125701790/980153461.jpg)
You can create and run an Outlook add-in the same way in Outlook on Mac as in the other hosts, including Outlook on the web, Windows, iOS, and Android, without customizing the JavaScript for each host. The same calls from the add-in to the JavaScript API for Office generally work the same way, except for the areas described in the following table.
For more information, see Deploy and install Outlook add-ins for testing.
Area | Outlook on the web, Windows, and mobile devices | Outlook on Mac |
---|---|---|
Supported versions of office.js and Office Add-ins manifest schema | All APIs in Office.js and schema v1.1. |
saveAsync method fails when called from a meeting in compose mode. See Cannot save a meeting as a draft in Outlook for Mac by using Office JS API for a workaround. |
Instances of a recurring appointment series |
|
|
Recipient type of an appointment attendee | Can use EmailAddressDetails.recipientType to identify the recipient type of an attendee. | EmailAddressDetails.recipientType returns undefined for appointment attendees. |
Version string of the host | The format of the version string returned by diagnostics.hostVersion depends on the actual type of host. For example:
| An example of the version string returned by Diagnostics.hostVersion on Outlook on Mac: 15.0 (140325) |
Custom properties of an item | If the network goes down, an add-in can still access cached custom properties. | Because Outlook on Mac does not cache custom properties, if the network goes down, add-ins would not be able to access them. |
Attachment details | The content type and attachment names in an AttachmentDetails object depend on the type of host:
|
|
String representing the time zone in the dateTimeCreated and dateTimeModified properties | As an example: Thu Mar 13 2014 14:09:11 GMT+0800 (China Standard Time) | As an example: Thu Mar 13 2014 14:09:11 GMT+0800 (CST) |
Time accuracy of dateTimeCreated and dateTimeModified | If an add-in uses the following code, the accuracy is up to a millisecond:JSON.stringify(Office.context.mailbox.item, null, 4); | The accuracy is up to only a second. |