hi,
on the line "text;C:\Path\file.". I think this was ment to
be general. I think whoever wrote this ment for the user
to fill in the complete file path. So delete Path\file and
type in the correct file path and file name. should work
then.

-----Original 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

.