I need help getting activeworkbook.breaklink to work.
I am trying to write a piece of VBA which breaks all the links in workbook (all the links are to a MS-SQL database).
This code:
Produces the error message:Code:Dim objWBConnect As Object For Each objWBConnect In ActiveWorkbook.Connections ActiveWorkbook.BreakLink objWBConnect.Name, objWBConnect.Type Next objWBConnect
Method BreakLink of object '_Workbook' failed
Note that objWBConnect.Name & objWBConnect.Type contain valid values (Adjustments & 1 respectively)




Reply With Quote
