| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Dialog Box | Excel Discussion (Misc queries) | |||
| dismiss blanks in lookup | Excel Worksheet Functions | |||
| Preventing Form Dialog dismiss (Red X) | Excel Programming | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
| Macro Dialog Box Help | Excel Programming | |||
![msnews.microsoft.com[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
