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

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

.

I think it asks you because the connection path isn't valid. it looks like
it's missing the file extension.

your connection path should contain the "full path" of the text file your
querying
.Connection = "TEXT;C:\path\file.txt"
or
.Connection = "TEXT;C:\path\file.csv"

also, in your code, i didn't see a End With statement. be sure it's in your
actual code.


Matt
Blue Ridge Telecom

"Ronbo" wrote:

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

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