Hi
Yes you can break the links in an excel file but you would need to create a new code action in the excel vbo. If you create a new action and add in the below code it should break the link you have requested. The inputs are Handle, WorkBook and LinkToBreak. You need to pass in the link you want to break as it appears in the excel file e.g. if the link shows as C:\mydocs\mytestfile.xlsx then the link you pass as an input must match it exactly. I havent tested the code below but I think this is how it should look and hopefully it works for you.
Dim wb As Object
Dim excel As Object
Try
wb = GetWorkbook(Handle, Workbook)
excel = wb.Application
excel.ActiveWorkbook.BreakLink(LinkToBreak,1)
Success = True
Catch e As Exception
Success = False
Message = e.Message
Finally
wb = Nothing
End Try
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
#MVP
