Thread: 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

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
>