If you want to use an existing querytable, change the connection string,
then refresh the querytable.

Otherwise, delete the old querytable and create a new one.

--
Regards,
Tom Ogilvy


"Ronbo" wrote in message
...
I am creating a macro that imports data using;

Application.ScreenUpdating = False
With Selection.QueryTable
.Connection = _
"TEXT;C:\path\file."
BackgroundQuery:=True

Application.ScreenUpdating = True

It works perfect except that I have to manually input the
path and file name each time it runs i.e it stops and
shows the input dialog box.

I want it to do this automatically. It knows the path
and file name, yet asks for it.

As you can see I have used Application.ScreenUpdating =
False and changed BackgroundQuery:= to True.

Any ideas how to make this run w/o user input?

Thanks for any help or suggestions.

Regards