Removing warning messages

[j_Southern]

I use the following code to download Text files containing data into my applications

Please Login or Register  to view this content.

When this is run it works except that a window pops up asking which file to down load. This is not necessary as the Query already contains the identity of the file to be used.
It is also a problem to the user who will not in general know the name of the file.
Can this window be suppressed? Application.DisplayAlerts does not help.
John

[j_Southern]

As a follow up to my mornings post. As well as the text files called by the procedure above I connect to some data by an ODBC link set up in MSQuery.
There is a small modification to the above code.

Please Login or Register  to view this content.

This works without asking for the identity of the file to be downloaded.

Has anyone some ideas?