Recently, an overview of the new extensibility capabilities available for developers as part of the. In addition to the improvements discussed there, including connecting the applications you build to the data and services available in Office 365 and creating add-ins that connect to third-party services, we continue to support developers working in VBA by adding new objects and members to the VBA object model across nearly all the Office applications. One thing to note, our engineering focus is Office web add-ins – web add-ins work across devices and platforms, and developers enjoy a modern web development experience. Support for web add-ins is already available in Office 2013 and 2016 for Windows, Office for iPad, and Outlook for Mac today, and they’ll come to the rest of Office clients over time. Office 2016 for Windows New VBA object model features Several Office desktop applications have new features that are exposed in the VBA object model. Here are some of the highlights: • Excel has a new set of data import and shaping features that are based on Power Query technology and that let users query information in files, databases, Azure sites, and from other sources, and to combine queries.

To support this feature, Excel exposes the new Queries and WorkbookQuery objects, and their associated properties and methods. For more information about Power Query, see this and download this. Excel exposes several new methods on the WorksheetFunction object to enable forecasting of statistical functions. Finally, there are a number of new objects related to the existing Model object, such as the ModelFormatBoolean and ModelFormatCurrency objects, and many new properties on each of these new objects. • Outlook has added a new PreviewPane object and a new WordEditor property on that object, which allow access to the body of the message currently loaded in the preview pane. This property is intended to let Windows-Eyes and other screen readers to have access to the body of a message in the preview pane. • Project adds new Engagement and EngagementComment objects and associated methods and properties to allow programmatic access to engagements scheduled in a project. Download microsoft publisher for mac.

• Visio has added new OM to permit information rights management (IRM) of Visio documents. Office 2016 for Mac Since the launch of Office 2016 for Mac in July, Mac OS X users around the world have been able to take advantage of the highly anticipated new features and improvements since the 2011 release.

Office for Mac that comes with an Office 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. Updates are available from Microsoft AutoUpdate (MAU).

At the same time, some of our users also have sent us feedback requesting further improvements to our VBA support, particularly around VBA add-ins. In response to this feedback, we’ll further improve Office 2016 for Mac’s support for VBA add-ins. Specifically, we’ll be adding Office ribbon customization via Ribbon XML, and making other improvements to Word, Excel, and PowerPoint for Mac to match their Windows desktop versions. Ribbon customization via Ribbon XML We are excited to announce that with the latest Office for Mac update, you’ll be able to fully customize the ribbon across Word, Excel, and PowerPoint for the Mac using familiar Ribbon XML.

Here’s how the Mac Word ribbon looks with a custom tab. If you’ve been customizing the ribbon on Office for Windows, you’ll find the Mac experience to be very similar. However, there are certain important differences to know about, as described in the table below. Comparison of ribbon customization functionality in Office 2016 for Mac and Windows * Most familiar Office Fluent Control Identifiers are compatible with Office for Mac. Some may not be available.

** May support this in future. *** Office 2016 for Mac doesn’t support third-party COM-Add-ins.

No current plans to support these in the future. Ribbon customization via Ribbon XML is now available, however, it remains in preview and is disabled by default for this update. Follow the steps below to enable or disable it across Word, Excel and PowerPoint using the Terminal on Mac. To enable Ribbon XML: • Open Terminal. • Type this command: “defaults write com.microsoft.office EnableRibbonXmlDeveloperMode -bool YES” • Reboot the app. To disable Ribbon XML: • Open Terminal.