View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RLang RLang is offline
external usenet poster
 
Posts: 47
Default 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