Whenever I create data connections to CSV files, 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 with VBA? Right now I use this code, but it only cuts the connections and leaves the names intact.
ThanksDim vConnection For Each vConnection In ActiveWorkbook.Connections vConnection.Delete Next vConnection
Bookmarks