ExcelBanter - How do I access a Pivot Table using VBA for EXCEL when the pivot .

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I access a Pivot Table using VBA for EXCEL when the pivot . (https://www.excelbanter.com/excel-programming/327310-how-do-i-access-pivot-table-using-vba-excel-when-pivot.html)

JamesB

How do I access a Pivot Table using VBA for EXCEL when the pivot .

I am trying to write a macro to lookup data in a pivot table, but the pivot
table is in another workbook other than the one I am currently working in.
Do you have any sample code for doing this?

All times are GMT +1. The time now is 01:45 PM.