Try:
Application.DisplayAlerts = false

Greetz,
Rody

"msnews.microsoft.com" schreef in bericht
...
Hello Guys
I have written a simlpe macro that invokes text to column after refreshing
data imported fron Access. Is there a way to codify the dismissal of the
dialog box that pops up with do you wish to over- write the existing data
or similar.
I'll be grateful for any help.

Thanks
Kevan