Case study: Locating grids and writable regions in the PerformancePoint Add-in for Excel

This article provides sample Visual Basic for Applications (VBA) code that demonstrates how to locate the PerformancePoint Server input matrices in a Microsoft Office Excel workbook and all of the writable regions within each input matrix. Once you have located this information, it is then possible to programmatically manipulate information in the matrices. This article does not address when it is appropriate to leverage VBA to augment your Microsoft Office PerformancePoint Server 2007 planning solution via this mechanism.

Click here (https://go.microsoft.com/fwlink/?LinkId=144669) to download the case study. Download size: 160 KB