Problem with macro excel migrated from one pc to another, error "Invalid procedure call or argument" runtime 5

[leo1412bode]

My problem is that I import a macro from one PC to another, in my previous PC it worked perfectly and now that I run it on my new PC it does not work, I get an error "Invalid procedure call or argument" runtime 5.
Someone who can help me, I do not understand if it is the same code and the same version of office because it does not work.

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R1048576C7", Version:=6).CreatePivotTable TableDestination:= _
"Hoja!R3C1", TableName:="TablaDinámica1", DefaultVersion:=6

 

[yky]

Try enclosing all sheet names with single quotes, e.g. "'Sheet1'!R1C1:R1048576C7".