Error with Macro Trying to Update Links

[hazza147]

Hi,

Getting a Run-time error '1004': Method 'ChangeLink' of object '_Workbook' failed at the ActiveWorkbook line.

When running the following code:

Please Login or Register  to view this content.

Can anyone suggest an alternative code which would fix the above error? I have Googled this and tried a couple of suggestions but had no luck.

As always any help is greatly appreciated.

Thanks,
Harry

[hazza147]

Any suggestions?

[hazza147]

SOLVED. File paths were of the wrong format.