cancel
Showing results for 
Search instead for 
Did you mean: 

How to break excel external links

LuzBenitez
Level 3
Hi all, 
i'm needing to delete external connections from a workbook after importing a CSV file, has anyone experimented with this?
Thanks!

------------------------------
Luz Benitez
------------------------------
1 REPLY 1

LuzBenitez
Level 3
nevermind , it was simple, here is the code that did the trick
Dim wb As Object = GetWorkbook(handle, workbookname) dim conn as Object for each conn in wb.Connections conn.Delete next conn

------------------------------
Luz Benitez
------------------------------