Break Data Links

[pells]

I am trying to break a data link that doesn't exist anymore via VBA code across many workbooks and am using the following:

ActiveWorkbook.BreakLink Name:= "C:\Test\Test1.xlsm", Type:=xlExcelLinks

After trying to run this code, it doesnt work and I get the following error:

Method 'BreakLink' of object' _Workbook' failed

Does anyone know what I am doing wrong and what I need to change in my code so that it works please?

Many thanks for reading my post.

 

[Weaver]

Are you 100% sure the link exists exactly as your code suggests?

 

[pells]

Are you 100% sure the link exists exactly as your code suggests?

thanks for your reply. I have managed to fix it as I was referencing the data link incorrectly....

Thanks all.