Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I suppress user dialog in File Save As?
I need to have my macro execute the command ActiveWorkbook.SaveAs in a fully
automated mode. I need to have the macro suppress any user dialog boxes. If the file already exists, I want the preogram to overwrite any existing file with the same name. What command do I need to execute or what parameter do I need to set, in order to have Excel do this. Thanks. Tony Fremont, CA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I suppress user dialog in File Save As?
Hi Tony,
Try: Applicarion.DisplayAlerts = False 'Your code Applicarion.DisplayAlerts = True --- Regards, Norman "Tony Lin" wrote in message ... I need to have my macro execute the command ActiveWorkbook.SaveAs in a fully automated mode. I need to have the macro suppress any user dialog boxes. If the file already exists, I want the preogram to overwrite any existing file with the same name. What command do I need to execute or what parameter do I need to set, in order to have Excel do this. Thanks. Tony Fremont, CA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress Save Dialog Box | Excel Programming | |||
How do you disable save file dialog? | Setting up and Configuration of Excel | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming |