Run time error 1004

[VBABEGINER]

Getting an error on this..
Run time error 1004
Analysis.xlsx could not be found.

Path is correct.. What it can be, pls guide..

Range("A4").Select

ActiveSheet.PivotTables("PivotTable2").ChangePivotCache ActiveWorkbook. _
PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Pth & "\" & "[ANALYSIS.xlsx]Details!A:AF", Version:=xlPivotTableVersion14)


Sheets("Tie").Select
Range("B4").Select


ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh

 

[VBABEGINER]

Hi Guys, Pls revert if query is unable to understand..

 

[VBABEGINER]

No one understand the query...??
Pls look here..

 

[VBABEGINER]

Dear All Board member,

I believe this really simple for you..Can any one expert can respond on this...Really appriciate for help in advance...

Getting an error on this..
Run time error 1004
Analysis.xlsx could not be found.

Path is correct.. What it can be, pls guide..

Range("A4").Select

ActiveSheet.PivotTables("PivotTable2").ChangePivotCache ActiveWorkbook. _
PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Pth & "\" & "[ANALYSIS.xlsx]Details!A:AF", Version:=xlPivotTableVersion14)


Sheets("Tie").Select
Range("B4").Select


ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh

 

[VBABEGINER]

 

[Joe4]

That seems to imply that it may not be able find the file. You have posted how "Pth" is calculated, so there isn't much we can do to verify that you have done it correctly.

I would recommend doing this to see what it returns, and verify it is a valid path, file name, and sheet, and range. If you do not see any issue, please post here what this MsgBox returns:

MsgBox [COLOR=#333333][I]Pth & "\" & "[ANALYSIS.xlsx]Details!A:AF"[/I][/COLOR]