Importing Text files

[j_Southern]

I am writing a spread sheet to be placed on several individual work stations on a network. The main data sheets are kept as textfiles on the server and called down to the work station on opening the application
This is done using the following code:-

Please Login or Register  to view this content.

This works OK except it always generates a message window asking which file do we want to import. There are three text files dealt with this way, but I think that the QueryTables would define which text file to search for.
I have tried putting each textfile in its own separate path, this didn't help.

My question is. How can I eliminate this message?
The query ranges are dynamically named using "SheetName_Table" as the name

Thank you in anticipation
j_Southern

[Izandol]

You may change the range properties manually or in the code:

Please Login or Register  to view this content.

[j_Southern]

Izadol Many thanks for your interest. Your code does exactly what I needed. I had not realised that QueryTable had more properties.
j_Southern