title: Retrieve data from Pivot Table in Vba
body: <p>I have an excel work sheet which contains three pivot tables having Pivot Table Names as PivotTable1...PivotTable3 and Active field names as Country, Language and Printers respectively. What I need is to get all data in each pivot table to each string or string array. Any help will be very thankful. </p>