you can manually import data from a text file without saving the connection. I can not seem to duplicate this with VBA?

I have a spread sheet into which I will be making many txt imports and I don't need now want all the connections and range names that will be saved to the file.

The code bleow does have a work around that goes back and deletes the connections and range names after the import is complete, I was just wondering if there was a cleaner way?

Please Login or Register  to view this content.
any other suggestions to this code are obviously welcome.

Thanks