Changelink

[charlee63]

Each week I need to change about 30 links in a file. I am trying to write a macro to do this.
Sub Macro7()
ActiveWorkbook.ChangeLink Name:= _
"\\HFNMSFS01V\Data\PERISHABLES\Merchandising\Weekly Sales and Vouchers\7-22-23\DU Dairy Financial - 07-22-23.xlsm" _
, NewName:= _
"\\HFNMSFS01V\Data\PERISHABLES\Merchandising\Weekly Sales and Vouchers\7-29-23\DU Dairy Financial - 07-29-23.xlsm" _
, Type:=xlExcelLinks
End Sub

Get this error know this error and how to correct?

 

[GlennUK]

What checking have you done regarding whether the existing link specified is correct, and also that the replacement link file exists in the location specified?