I have the following code that TMS (one of the members here) gave me for deleting connections to data links. It does that, but I just realized that whenever you create data connections, excel also inserts names (can see these if go to Formulas tab > Name Manager) for each range where the data was inserted. Is there a way to also delete these names?
Thanks![]()
Dim vConnection For Each vConnection In ActiveWorkbook.Connections vConnection.Delete Next vConnection
Bookmarks