deleting names associated with connections to CSV files

[luv2glyd]

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.

Please Login or Register  to view this content.

Thanks

[LJMetzger]

Hi,

If you are not using the 'Name Manager', it can easily be done as follows:

Please Login or Register  to view this content.

To delete a specific 'Named Range':

Please Login or Register  to view this content.

If you are using the 'Name Manager', there must be a way to identify the 'Named Ranges' that you want to eliminate.

Lewis

[luv2glyd]

Great! Thanks for the code, Lewis. Yes, each name that I wanted to delete started with the same five letters, so I did:

Please Login or Register  to view this content.

[LJMetzger]

Thanks again for the rep points. When you have a naming convention like you do, it makes life a lot easier. Good job.

[luv2glyd]

You're welcome. Thanks - still learning all that VB can do, but getting a bit better every day.