If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel 2007 macro recorded pivot table
I record a macro in excel 2007 in which i create a pivot table. when i try to
run the macro i get "invalid procedure call or argument". the same process works fine in excel 2003. If i look at the debug window the "problem code" is : -ActiveWorkbook.PivotCaches.Create(SourceType:=xlDa tabase, SourceData:= _ "JDE Import!R1C1:R3500C37", Version:=xlPivotTableVersion12).CreatePivotTable _ TableDestination:="Calculations & summary!R4C3", TableName:="PivotTable7", _ DefaultVersion:=xlPivotTableVersion12 I guess this gives two questions: how can a recorded macro then not work again? (i have cleared, removed and recreated the destination sheet and all sorts) and two, what is wrong with the macro itself? |
#2
|
|||
|
|||
excel 2007 macro recorded pivot table
Actually, it is fairly common for a recorded macro to not work "out of the
box"- they often need just a tiny bit of tweaking. I'm not a big pivot-table automator, and without seeing the rest of the macro, it is hard to tell what the problem might be- the wrong sheet might be active, etc. I'd suggest you post a followup to the Excel.programming newsgroup, and include all (or at least a larger chunk) of the code that preceeds the line where it errors out. HTH, Keith "getting old" wrote: I record a macro in excel 2007 in which i create a pivot table. when i try to run the macro i get "invalid procedure call or argument". the same process works fine in excel 2003. If i look at the debug window the "problem code" is : -ActiveWorkbook.PivotCaches.Create(SourceType:=xlDa tabase, SourceData:= _ "JDE Import!R1C1:R3500C37", Version:=xlPivotTableVersion12).CreatePivotTable _ TableDestination:="Calculations & summary!R4C3", TableName:="PivotTable7", _ DefaultVersion:=xlPivotTableVersion12 I guess this gives two questions: how can a recorded macro then not work again? (i have cleared, removed and recreated the destination sheet and all sorts) and two, what is wrong with the macro itself? |
#3
|
|||
|
|||
excel 2007 macro recorded pivot table
Hi
The problem is xlPivotTableVersion12 For XL2003 change to xlPivotTableVersion11 -- Regards Roger Govier getting old wrote: I record a macro in excel 2007 in which i create a pivot table. when i try to run the macro i get "invalid procedure call or argument". the same process works fine in excel 2003. If i look at the debug window the "problem code" is : -ActiveWorkbook.PivotCaches.Create(SourceType:=xlDa tabase, SourceData:= _ "JDE Import!R1C1:R3500C37", Version:=xlPivotTableVersion12).CreatePivotTable _ TableDestination:="Calculations & summary!R4C3", TableName:="PivotTable7", _ DefaultVersion:=xlPivotTableVersion12 I guess this gives two questions: how can a recorded macro then not work again? (i have cleared, removed and recreated the destination sheet and all sorts) and two, what is wrong with the macro itself? |
Thread Tools | |
Display Modes | |
|
|