>Hi: What is the correct syntax for creating an excel pivot table. I have looked at excel's code for doing this but it is far from straightforward. So far, I have the following:
>
>

>top_cell     = oCalcs.Range("a2:a2")
>calcs_range  = oCalcs.Range(top_cell,lastCell)
>oSourceData = oCalcs.Range(top_cell,lastCell)  && here is the source range data for the pivot table
>oDestination = oWorkBook2.Sheets("2").range("a1:a1")  && here is the range for where the table will go
>
>** code to create pivot table ??
>

>

I wrote an article about this not long ago, but it's not on my website yet. It was in FoxRockX sometime last year.

Tamar