Pivot Tables and VBA / RunCommand Constants

[Darrell]

Hi,

I'm trying to figure out how to change the row, column,
data fields w/in pivot tables using VBA, not the pivot
table wizard. Can anyone help?

Also,
Does anyone know where you can get a description of what
each constant of RunCommand (the AcCommand Class) is
supposed to do?

Thanks,

Darrell

 

[Dan]

I don't know if it will help or not, but here is a link
to programmaticaly build a Pivot Chart:

http://support.microsoft.com/?kbid=304143