programmatically change pivot table rows/columns
 

Hi all,

I have a Pivot table that is built on an OLAP cube. I would like to be
able to pop up a dialog (in Excel) and ask the user to select a date
range.

Then, using this date range, programmatically change the [Time]
dimension in my pivot table so that only this range is displayed.

Anybody has any idea how this can be done?

Thanks,
L