ExcelBanter - Obtain grand totals from a PivotTable

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

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

- - Obtain grand totals from a PivotTable (https://www.excelbanter.com/excel-programming/360482-obtain-grand-totals-pivottable.html)

Tony @ Byram

Obtain grand totals from a PivotTable

Within Access I am opening a an Excel spreadsheet and manupulating a
PivotTable that resides in that spreadsheet.
Can you tell me how to obtain the grand totals directly from the PivotTable
class?
Many Thanks,
Tony

All times are GMT +1. The time now is 03:25 PM.