Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As Overwrite
Is there some way to keep the window that tells me that a file already exists and do I want to overwrite it from popping up and let a worksheet save as execute? give that fStr hold the name of the file Set wb = ActiveWorkbook wb.SaveAs (fStr) is what I have now....but I get the message. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As Overwrite
Hi Marston.
One way: Set wb = ActiveWorkbook Application.DisplayAlerts = False wb.SaveAs (fStr) Application.DisplayAlerts = True --- Regards, Norman " wrote in message ... Is there some way to keep the window that tells me that a file already exists and do I want to overwrite it from popping up and let a worksheet save as execute? give that fStr hold the name of the file Set wb = ActiveWorkbook wb.SaveAs (fStr) is what I have now....but I get the message. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As / Overwrite | Excel Discussion (Misc queries) | |||
How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
Save a Copy/Overwrite changes dialog box | Excel Discussion (Misc queries) | |||
Save .csv with overwrite | Excel Programming | |||
Save As without overwrite prompt | Excel Programming |