Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In cell "A1" I've created a Query using the wizard that simply imports
the contents of a Text file. I've now recorded a macro to update this query: Range("A1").QueryTable.Refresh BackgroundQuery:=True and I've also tried: Application.DisplayAlerts = False Range("A1").QueryTable.Refresh BackgroundQuery:=True Application.DisplayAlerts = True When I run either of these and annoying dialog box appears named "Import Text File" and I have to press "Import" for the macro to continue Anyone any ideas how to get rid of this, or am I up againsta brickwall? (there is a workaround but I'd rather plow straight ahead) Any help greatly appreciated Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Annoying Replace Dialog Box | Excel Discussion (Misc queries) | |||
allow user to disable annoying warning dialog on log charts | Charts and Charting in Excel | |||
Annoying pop up | Excel Discussion (Misc queries) | |||
Excel's annoying "Getting Started" dialog box. | Excel Discussion (Misc queries) | |||
control of dialog macro dialog box. on open | Excel Programming |