Perform the action manually in Excel with the macro recorder turned on -
then examine the recorded code. View the Object model for Pivot Tables and
Caches and look in the VBA help.

--
Regards,
Tom Ogilvy

"Todd F." wrote in message
...
Hi i would like to get invloved with automating pivots.

I suppose it might be better to automate parts of the process at first and
then work into full-automation ( comments welcome)

The first thing I thought of was a macro to assign to a button to launch
pivot dialog, build on external new sheet, and take me to the layout
section
of the build process so I can pick fields.

Can this be done in a macro.

what is the best way to learn about pivot process interaction and macro
building related to pivots.

Thanks Todd