Possible to select an OWC 10 Pivot Table cell?
I don't know if it is the right place to raise this question.
The situation is that I want to return the ADO recordset object from
an OWC 10 Pivot Table in my hta application. There is no problem if a
Pivot Table cell is made active by manual click.
My problem is that how could I return an ADO recordset object without manual click on a Pivot Table cell? So I try to look for the
OWC 10 reference to find a way to make a Pivot Table cell active by VBScript.
However, I can't find anyway to achieve this target.Could anyone tell me if it is possible to select a Pivot Table cell by VBScript?