query data from a pivot table using a macro

[ali_hijazi]

Hello

I got a pivot table

is there a way to query data from this pivot table using a macro

the pivot table got only one row with data the rest show null in the expression

[swuehl]

You want the content of a pivot table's cell (like in your other post)?

So maybe like this (taken from the example and posted to your other post, too):

set table = ActiveDocument.GetSheetObject( "CH01" )

for RowIter = 0 to table.GetRowCount-1

    for ColIter =0 to table.GetColumnCount-1

        set cell = table.GetCell(RowIter,ColIter)

        msgbox(cell.Text)

    next

next

Regards,

Stefan