Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I would like to build macro's to do pivots or part of pivots
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I would like to build macro's to do pivots or part of pivots
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." 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivots | Charts and Charting in Excel | |||
several pivots | Excel Discussion (Misc queries) | |||
Automatic pivots | Excel Discussion (Misc queries) | |||
Quickie on Pivots | Excel Discussion (Misc queries) | |||
Pivots using other pivots and dynamic query problem | Excel Programming |