I use the following sub to import data from Text files.
[CODE][/Function QueryOnly(SheetName As String)
Application.DisplayAlerts = False

On Error Resume Next
Worksheets(SheetName).Activate
Range(SheetName & "_Clear").Clear
Range(SheetName & "_Table").QueryTable.Refresh BackgroundQuery:=False
Application.DisplayAlerts = True

End FunctionCODE]
When I call this code I am asked to select the file to be imported using a browse window. This is not very helpful as my users would not necessarily know which file to select.
I Think that the QueryTable already has the information anyway, is there any way that the browse window can be suppressed?
John