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