How do I 'Select' my Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2003, how do you refer to a Pivot Table object in VBA? It does not
have a Name property, but ‘Help’ describes the programmatic identifier for
the PivotTable object as CLSID:0002E552-0000-0000-C000-000000000046

I have experimented with this but with no success. There is an example in
‘Help’ but only in HTML.

My problem is that I need to use VBA to select the Pivot Table (as in
pressing the keys Ctrl and A together).

Thanks for any help on this!!
Rick
 
No need for that on a Friday! I am quoting Microsoft's own help pages.
What planet are you on?
 
Back
Top