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.Office 2016 for Windows New VBA object model features Several Office desktop applications have new features that are exposed in the VBA object model. Support for web add-ins is already available in Office 20 for Windows, Office for iPad, and Outlook for Mac today, and they’ll come to the rest of Office clients over time. 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. 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. Recently, an overview of the new extensibility capabilities available for developers as part of the. Learn how to create, format, and print a wide variety of documents in Microsoft Word for Mac 2016.