I have recorded the macro to create the dynamic report depend on the particular data .The code is working fine when i have recorded in MS 2007 but when i recorded in MS 2003 its giving me error as "Invalid Procedure call or argument.
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R3421C7").CreatePivotTable TableDestination:= _
"[Book1.xls]Sheet2!R2C1", TableName:="PivotTable1", DefaultVersion:= _
The part of code i have attached where i am getting the error.
Please can somebody help me out this its urgent!!!!