Someone Please Help with pivot table macro

[vash]

Could Someone tell me what is wrong with the following lines of code.

Activesheet.PivotTables("PivotTable2").PivotFields("Upd_date").Name = "Daily"
ActiveSheet.PivotTables("PivotTable2").PivotFields("Week_Desc").Name = "weekly"

i wrote these lines of code in Excel 97 and they worked fine, but upon opening them in Excel 2000 i get the following error in my Pivottable

Run-Time error '1004'
Unable to set the Name Property of the PivotField class

and when i went to the debugger it pointed to the second line of this code. So i commented that line out and got the following error

Run-Time error '1004'
Unable to set PivotField Property of the PivotTables class

coudl someone please help me, is there something that i am missing since i got excel 2000, do they use a different name now or something... or whats wrong...im completely stuck.

Edited to make the topic more informative. ~ Von Pookie

 

[Dave Patton]

Re: Someone Please Help

You could try Macro Recorder and see what code it provides.

I do not have both versions of Excel at hand.

 

[vash]

It didnt work, any other ideas?!

 

[Josue Barocio]

I've used pivot table macros written in Excel 97 on Excel 2000 with no difficulty.

Why don't you post the entire script dealing with the pivot table commands. I can run them in Excel 97 and 2000 to see what may be wrong.

Regards,

Joe