Hi

I am trying to find a way to programmatically read the sub-total values from
the data field of a pivot table. The problem is that i don't seem to be able
to access the single pivot items in the Data Field. I read a KB article
describing this as a problem in MS Excel's object model
(http://support.microsoft.com/default...en-us;Q213455). Anyway the
suggested workaround doesn't work as even when accessing the fields from
the'VisibleFields' property of the pivot table object instead of 'DataFields'
I get exactly the same field objects among which the one generated by the
aggregate function 'Count of..', which contains no pivot items.

Is there another way to read the values of the generated sub totals in a
pivot table or am i doing something wrong?

--
Thanks in advance
/Enrico

have you tried GetPivotDATA worksheet function?




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Enrico Campidoglio wrote :

Hi

I am trying to find a way to programmatically read the sub-total
values from the data field of a pivot table. The problem is that i
don't seem to be able to access the single pivot items in the Data
Field. I read a KB article describing this as a problem in MS Excel's
object model
(http://support.microsoft.com/default...en-us;Q213455).
Anyway the suggested workaround doesn't work as even when accessing
the fields from the'VisibleFields' property of the pivot table object
instead of 'DataFields' I get exactly the same field objects among
which the one generated by the aggregate function 'Count of..', which
contains no pivot items.

Is there another way to read the values of the generated sub totals
in a pivot table or am i doing something wrong?

That's it! Thanks a lot

--
/Enrico


"keepITcool" wrote:



have you tried GetPivotDATA worksheet function?




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Enrico Campidoglio wrote :

Hi

I am trying to find a way to programmatically read the sub-total
values from the data field of a pivot table. The problem is that i
don't seem to be able to access the single pivot items in the Data
Field. I read a KB article describing this as a problem in MS Excel's
object model
(http://support.microsoft.com/default...en-us;Q213455).
Anyway the suggested workaround doesn't work as even when accessing
the fields from the'VisibleFields' property of the pivot table object
instead of 'DataFields' I get exactly the same field objects among
which the one generated by the aggregate function 'Count of..', which
contains no pivot items.

Is there another way to read the values of the generated sub totals
in a pivot table or am i doing something wrong?