Query Refresh without filename prompt
 

Hi,
I'm refreshing a worksheet query that refers to a text file and I can't
quite figure out what code is necessary to avoid the dialog box asking for
the source file name each time. The path is c:\temp\generic.txt". Thanks
for the help.

Sub Macro4()
ActiveSheet.QueryTables(1).Refresh
End Sub

Query Refresh without filename prompt
 

Never Mind. Figured it out.

"RLang" wrote:

Hi,
I'm refreshing a worksheet query that refers to a text file and I can't
quite figure out what code is necessary to avoid the dialog box asking for
the source file name each time. The path is c:\temp\generic.txt". Thanks
for the help.

Sub Macro4()
ActiveSheet.QueryTables(1).Refresh
End Sub