Pivot Table, recoded code vs mine, neither works!

[am_hawk]

errors:
5 - invalid procedure call

1004 - Uanble to get the pivotTables property of the worksheet class

i've recorded the following Macro, however using it as Auto_Open give me error 1004.

I tried playing with the code and I am stuck, I cannot get it to work. If anyone could please provide some feedback. I am new to VB.

My code clears a couple sheets on open(delete the old pivot/temp info), then copies a web query to a temporary sheet then I insert my "categories" above the query that I need in my pivot table, then I pivot, move the categories to column,row,count. copy the grand total cells to the adjacent cells to be referenced by another workbook. Why is the recorded macro not working? how can i modify the code to get it working?

Thanks!!!

Please Login or Register  to view this content.

[nathansav]

where does it error? can you attach?

[am_hawk]

Please Login or Register  to view this content.

[am_hawk]

Instead of creating a new pivot table, i am simply refreshing my web query and then refreshing the pivot table. Thanks for the help.

[apo]

Hi..

Perhaps just remove the semi colon from your PivotFields section... I am assuming that your column/row doesn't include a semi colon in it?

Example..

Please Login or Register  to view this content.