Annoying Dialog Box
 

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

Annoying Dialog Box
 

Before you refresh your data (or even when you originally create the
query) set the following Data Range Property (it's very long name
describes exactly what it is)

Range("A1").QueryTable.TextFilePromptOnRefresh = True

----
Sean
"Just press the off switch, and go to sleep!"

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Annoying Dialog Box
 

I cannot duplicate, but sounds like the macro security
level may be invoking the popup.

Try lowering the Macro Security Level
tools...macro..security.



-----Original Message-----
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
.