Using VBA to enhance interactivity of PowerPivot reports

PowerPivot currently has no programmatic interface, so there is really no automated way to leverage its capabilities (other than those provided by PowerPivot for SharePoint). However, we must remember that one way to consume PowerPivot data is through an Excel pivot table (there are others, like Excel Cube functions). Pivot tables do have an API, which allows for a certain degree of programmatic interactivity with PowerPivot data.