Query Refresh without filename prompt

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable refresh problem 1
Excel VBA SQL Query Filename 3
VB refresh of query 2
Workbook Open bypasses Query Refresh 3
External Data Query 2
Refresh pivot - catch 22? 2
Use external file variable in formula 2
Selecting a specific sheet by codename in an opened workbook (XL03 2

Top