How do I 'Select' my Pivot Table

R

RickW

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
 
R

RickW

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

Pivot Table showing white square instead of component on some PCs 1
Change report firlds in pivot tables and charts with one selection 0
Access OWC embedded in WebBrowser 1
Hyperlink in pivot table 20
Cannot render OWC 10.0 Pivot tables in FP2003 2
OWC 11 objects on an HTML page 1
Pivot Chart only charting one series when Pivot Table shows two C# and ASP.net 0
need help with OWC 10 Pivot table display 0

Top