Pivot Table totals from vba

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Access 2003

Does anyone know if its possible for me to access the grand totals for
the row in a pivot table via VBA. I want to extract the totals for
each row.
 
Did you ever solve this, Andy?

I have a pivot table that groups and sums on money amounts and transactions.
I wish to write a function that will act on the key field and the pivot
totals, in order to return a fee from a range of fees.

Any advice would be much appreciated, as I haven't coded against a pivot
table before.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
How to export table from outlook into ms access table? 0
Pivot tables 2
Excel VBA For excel 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Pivot Table Row Totals 6
How to ignore a column of numbers in Grand Total for rows 1
How to change Pivot Table external data source (MS Access Database)by VBA 0

Back
Top