Name Delete Problem Again

[Meme]

Hi all,

I've posted this question the other day and someone gave
a piece of code to delete the names . But somehow the
code can not delete the names. Here is my problem again:
I have a workbook contains worksheet A , B ,and C.
My macro transfering data from several .prn files to
sheet B , then do some query and copy-paste the results
to sheet C. While in the middle of running the macro, it
created tens of names like "externaldata-
23", ..."externalnata_40". My question is how can I get
rid of those names ???
Please help!
By the way , anyone know how to avoid creating all these
unnecessary names ???

Thanks so much in advance
Meme

 

[Dave Peterson]

Stop using the queries????

It looks like these are names that the queries use.

If you work with names a lot, do yourself a favor and get this addin:

Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager.

http://www.jkp-ads.com/Download.htm

Life will be a lot nicer!

===
I'm not sure what the code was and why it didn't work for you.