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 ??

Thank you, Steve