Dismiss a dialog box (Via a Macro)
 

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

Dismiss a dialog box (Via a Macro)
 

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

Dismiss a dialog box (Via a Macro)
 

Rody
Thanks very much! It worked like a charm.
Kevan
"Rody Meulman" wrote in message
...
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

Dismiss a dialog box (Via a Macro)
 

Rody
Thanks very much it worked like a charm.
Kevan
"Rody Meulman" wrote in message
...
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