hi
well and good. and i hope everything works out for you and my advice not
needed. but i would keep my suggestion for future use just in case.

Regards
FSt1

"Dave" wrote:

Hi FSt1
I am importing the text data into a workbook which is generated by a
template. Data will only be imported once into each workbook, although the
template will be used by many people to generate many workbooks (one for each
job). The macro is for the template.
Regards - Dave.

"FSt1" wrote:

hi
i may be late but...
the code your are running creates a new query table each time it is run. if
you are connecting to the same data source, then you need not run it a second
time, only refresh the querytable.
but i suspect that you are importing different text files from different
places so i would strongly advise that you add code to delete the old
querytable and it's named range reference before you run the code "as is" to
prevent any conflict.

Regards
FSt1


"Dave" wrote:

Hi Dave,
Exactly what I needed.
Thanks a lot!
Regards - Dave.