OWC 9 - getting text from one cell of a Pivot Table

G

grant babb

Because of backward-compatibility frustrations we have to use OWC 9 for an application.

I can not seem to suss out the object model. All I want to do is get the text from the first cell of the active row in the Pivot Table.

Please forgive me if I am asking something terribly obvious, but I can't seem to access any of the properties that should be available (according to VB OWC reference).

Thanks in Advance,
grant babb
L-EET Web Services
http://www.l-eet.com/
 
D

Dan Ricker

There are differences between the OWC9 and OWC10 object model. Make sure you are looking at a reference for OWC9. If you have OWC9 in a VB6 application, the Object browser will be of assistance.

Things that may be of interest:

PivotTable1.Selection
PivotTable1.ActiveData.ColumnMembers
PivotTable1.ActiveData.RowMembers

Dan
 

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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Retrieve member values for filters in OWC pivot table 0
OWC 11 Pivot table. 4
Word VBA - Automatic change content of a cell in table using dropdown list 5
OWC 11 Pivot Table and SSAS 2005 Cube 3
Sample wanted: Winform with OWC Pivot table to browse a cube 0
OWC pivot table events in a winform 1
Access 2003 runtime and the OWC pivot table 0

Top