I would like to build macro's to do pivots or part of pivots

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

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." <ToddF@discussions.microsoft.com> wrote in message
news:75BF1DD7-66B3-413A-B274-15F47F702DBA@microsoft.com...
> 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

thanks

"Tom Ogilvy" wrote:

> 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." <ToddF@discussions.microsoft.com> wrote in message
> news:75BF1DD7-66B3-413A-B274-15F47F702DBA@microsoft.com...
> > 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
>
>
>