Hi all:

I have use Excel Pivot table to deliver the Olap data from SQL Analysis Server. However, I can not find any good reference about programming the PivotCaches and PivotTables classes.

Here are the actions that I want to automate by writting Excel Macro:

1. I find that to check or un-check the selection list in the Dimension fields is very unefficienct. For example, if I use the Product Dimension (1200 memebers) as the Row Field, and then I find out that I only interest on the 100 memebers. As a result, I need to check those members in the selection list. As a result, I want to write a marco to check those 100 members automaticaly.

2. I want to copy all the members select in a particular Page field into other worksheet. I try to use PivotTable.PageFileds to get the list of item select by the user. However, If the user select multiple item in the Page field. The item in the PivotTable.PageFileds .PivotItem.Name always equal to [multiple item], instead of the actual name of the members.


Thanks,

ken ken