Is it a CSV file? If so, then just open it in Excel, then copy the data to
your template and close the original file without saving. (with code of
course).

Even if it isn't, you might still be able to use this approach using
OpenText

--
Regards,
Tom Ogilvy

"DennisW" wrote in message
...
I import a text file into an excel template, and every import creates a
name
for the imported data range. Is there a way to (1) prevent creating a
Range
Name on import, (2) delete the Range Name at the end of the import macro,
or
(3) delete the last Range Name from the .Names Collection?

I don't want to delete all names because I want to keep some of the
existing range names.