Extract pivot table info
 

Hi,

I have a pivot table which has filters in the page
fields. When the user selects the filters i want to
retrieve the filter information and store it for later
use. How do i do that using VBA?

-Jaya

Extract pivot table info
 

For a pagefield, the filter would be the value showing.

? Activesheet.PivotTables(1).PageFields(1).CurrentPa ge
A

Regards,
Tom Ogilvy


"jaya" wrote in message
...
Hi,

I have a pivot table which has filters in the page
fields. When the user selects the filters i want to
retrieve the filter information and store it for later
use. How do i do that using VBA?

-Jaya

Extract pivot table info
 

I tried that and i get an error,

Unable to get the currentpage property of the pivottable
class. I am using excel2000.

-Jaya

-----Original Message-----
For a pagefield, the filter would be the value showing.

? Activesheet.PivotTables(1).PageFields(1).CurrentPa ge
A

Regards,
Tom Ogilvy


"jaya" wrote in message
...
Hi,

I have a pivot table which has filters in the page
fields. When the user selects the filters i want to
retrieve the filter information and store it for later
use. How do i do that using VBA?

-Jaya


.