VBA, changeLink error

[francosueho82]

Dear all,
i have below question:
Periodically i will download a new file from the systems and update the old one in my excel file.
for example, i fill use New File to replace the Old file , VBA i write , such as :

ActiveWorkbook.ChangeLink Name:=Oldfilename, NewName:=Newfilename, Type:=xlExcelLinks

however, error message prompt after run:
Run-time error' 1004' Method 'Changelink of Object'_workbook failed.

i can confirm that both path of the new and old file are correct. can you some help to give me some advice ?

THank you very much for your kindness.

 

[dermie_72]

Does this link help?Method 'ChangeLink' of object '_Workbook' Failed