VBA Code to Get Pivot Field Properties

[weaverjohn]

I have a pivot table of data that was pulled from and SQL server. The fields have a several properties. I need to examine the value in one of the properties ("Period End Date") to determine which field to start my charts with each period.

Right Clicking on the Field the Pop-up menu has a selection for "Show Properties in Report" and a sub-menu to show a particular property. What I need to do is to look at the properties via VBA. I've looked everywhere I can think of with no luck.

I thought I would pose the questions to all the smart folks that hang around MrExcel.com

Thanks,

John