How do I 'Select' my Pivot Table

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
 
G

Guest

No need for that on a Friday! I am quoting Microsoft's own help pages.
What planet are you on?
 

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

Cannot render OWC 10.0 Pivot tables in FP2003 2
Access 2003 pivot table subform 0
Pivot table multiple filters 2
View Pivot Table Source data as a Data Table 6
Pivot Table question 1
Pivot Table Macro Run-time error 3
How do I enable the "Opening Mail Attachment" warning 0
Playing back a Pivot Table macros 2

Top