Excel - question
I have a file that a macro copies a few sheets out of and breaks link. I want to write some code that will break the link rather than hard code.So far I have
x = ActiveWorkbook.Path
y = ActiveWorkbook.Name
z = x + y
ActiveWorkbook.BreakLink Name:= _
x, Type:=xlExcelLinks
However I can not get it to work, I have also tried X in "".
Only second post and apologies for basic question
I have a file that a macro copies a few sheets out of and breaks link. I want to write some code that will break the link rather than hard code.So far I have
x = ActiveWorkbook.Path
y = ActiveWorkbook.Name
z = x + y
ActiveWorkbook.BreakLink Name:= _
x, Type:=xlExcelLinks
However I can not get it to work, I have also tried X in "".
Only second post and apologies for basic question