G'Day,

I've noticed that importing a text file via a macro
(using .QueryTables.Add) also adds a new defined range name.

I'd like to delete the new name after it is added to stop an
accumulation of range names.

I haven't noticed any pattern to where the new name is added to the
Names collection - in one test case, with 24 current names, the new
name was added at position number 7.

Can anyone explain how the new names are added to the Names collection
so they can be deleted easily?

I'm not too sure about the naming of the added defined name either.

Thanks,

Clive