How to break excel external links
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-10-20 04:48 PM
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
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-10-20 11:02 PM
nevermind , it was simple, here is the code that did the trick
------------------------------
Luz Benitez
------------------------------
Dim wb As Object = GetWorkbook(handle, workbookname)
dim conn as Object
for each conn in wb.Connections
conn.Delete
next conn
------------------------------
Luz Benitez
------------------------------
