Clear names Cells / Ranges

Hi
I am importing a database from a file. "Txt" as follows:

Please Login or Register  to view this content.

Everything ok so far, and the range of cells that contains the imported base, takes the name as defined in ". AddBASE Name =" growing "NOVABASE".

Turns out I need to renew this base a few times, and after the second time the macro starts automatically add "_1", "_2", etc. ... as qty of times repeat the process, becoming "NOVABASE_1", "NOVABASE_2", etc..

Even if I delete this intervaldo before importation, with the command:

Please Login or Register  to view this content.

He can clear the interval, but the next, he takes with the new rule.

I need a soloção with two hypotheses.

1st) Either the macro recognize anything after hunderline, type [ode] ActiveWorkbook.Names (addBASE & "_" & *). Delete [/ code] erasing this interval so that later I can name it right, or;
2nd) Some macro to clear all names interlavos defined.
Thank you!!!

Hi

Any idea?
Thank you!!

Hi

Any idea?
Thank you!!