Exporting to Excel using Copy

[Jeremy Lukins]

For various reasons we have to use Version 9.0 of the OWC.
I am trying to export a pivot table to Excel but need to
do it manually.

What I want to do is mimick selecting all of the pivot
table and pasting it into Excel. This takes seconds,
whereas my manual export takes minutes.

How do I "select" the whole pivot table through code?

Thanks.