Chapter 15. Automating operations using VBA

Microsoft Visual Basic for Applications (VBA) is a powerful language included in Microsoft Excel that you can use to automate many operations. In Excel 2013, Microsoft extended the VBA library of objects with the DataModel object, which you can use to perform some operations with the PowerPivot data model. Not all the PowerPivot features are available in this first version; many operations (such as adding a calculated column or a calculated field) are still available only through the user interface. But there are some useful features you can use to build interactive and automated reports.

In this chapter, you are going to see some examples of VBA usage. We will not describe in full detail in this book ...

Get Microsoft Excel 2013: Building Data Models with PowerPivot now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.