excel 2007 macro recorded pivot table

G

getting old

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:=xlDatabase, 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?
 
K

ker_01

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
 
R

Roger Govier

Hi

The problem is
xlPivotTableVersion12

For XL2003 change to
xlPivotTableVersion11
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Macro 1
Pivot table and it's macro 1
Programming a macro in Excel Office 2007 to create Pivot Table 1
Pivot Table Macro with dynamic source data 1
macro creating new pivot table 2
Pivot Table Macro 2
Creating a Pivot Table via Macro - Errors on Recorded Code 3
syntax in VBA to create a pivot table 2

Top