| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prompt for query refresh criteria | Excel Discussion (Misc queries) | |||
| disable query refresh prompt? | Excel Discussion (Misc queries) | |||
| Prompt user for a filename | Excel Programming | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Hybrid Mode
