Macro runs on one computer and get run time error 5 on another

[LenaMWork]

Hello!

I run a macro on one computer and it is fine
And on another it gives me the run time error 5: invalid procedure call or argument

This is the code he doesn`t like:


ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
Range(Cells(1, 1), Cells(R, C)), Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="ProjectsOW!R3C1", TableName:="PivotTable3", DefaultVersion _
:=xlPivotTableVersion15

Please help!

 

[JackDanIce]

Welcome to the board. Are the Excel versions the same on each PC?

 

[LenaMWork]

Welcome to the board. Are the Excel versions the same on each PC?

Hi!

No, on the PC it works on it`s excel 2013 and on the one it doesn`t work it`s 2010

I also read this solution: https://support.microsoft.com/en-us/kb/940166

But it doesn`t apply to me since I need the sheets to be named by a specific name

 

[JackDanIce]

It would appear that the version (xlPivotTableVersion15) is invalid for Excel 2010, hence the error message. I found this online:
Issue with vba creating a pivot table, is this an excel version issue? - Stack Overflow

Try changing the 15 to 14 and see if resolves.

 

[LenaMWork]

Hi...

changed it to 14 and is still gives me the same error at the same spot..

 

[LenaMWork]

It would appear that the version (xlPivotTableVersion15) is invalid for Excel 2010, hence the error message. I found this online:
Issue with vba creating a pivot table, is this an excel version issue? - Stack Overflow

Try changing the 15 to 14 and see if resolves.

Hi!

It Worked!!!

Thank you!!!

 

[JackDanIce]

Please post your full code

 

[LenaMWork]

It is ok!

It works now!

You were right, it`s the different version of the pivot tables.
As soon as I changed it from 15 to 14 it worked like a charm!
It didn`t work at first since I forgot to change in all the places in the code

Thank you so much!!!!
You saved me

 

[LenaMWork]

Please post your full code

It is ok!

It works now!

You were right, it`s the different version of the pivot tables.
As soon as I changed it from 15 to 14 it worked like a charm!
It didn`t work at first since I forgot to change in all the places in the code

Thank you so much!!!!
You saved me

 

[JackDanIce]

You're welcome.

PS You don't need to quote every comment in your replies or post double replies either!