| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overwriting a file automatically using saveas in a macro
I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro?
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwriting a file automatically using saveas in a macro
Hi Sam,
Precede the code with Application.DisplayAlerts = False and reset to true afterwards -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Sam" wrote in message ... I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwriting a file automatically using saveas in a macro
Hi
use application.displayalerts = false before your statement and application.displayalerts = True after this -----Original Message----- I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro? Thanks . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwriting a file automatically using saveas in a macro
displayalerts does not work with the overwrite msgbox of SaveAs
----- Frank Kabel wrote: ---- H us application.displayalerts = fals before your statement and application.displayalerts = Tru after thi -----Original Message---- I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro? Thank |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwriting a file automatically using saveas in a macro
Hi
works for me.you may post the relevant part of your code -----Original Message----- displayalerts does not work with the overwrite msgbox of SaveAs! ----- Frank Kabel wrote: ----- Hi use application.displayalerts = false before your statement and application.displayalerts = True after this -----Original Message----- I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro? Thanks . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwriting a file automatically using saveas in a macro
It's always worked for me, too.
But maybe you could just kill the existing name first. on error resume next kill myFileNameWithPathHere on error goto 0 'do your save The "on error resume next" says to ignore any error if the file doesn't actually exist. doesn't apply wrote: displayalerts does not work with the overwrite msgbox of SaveAs! ----- Frank Kabel wrote: ----- Hi use application.displayalerts = false before your statement and application.displayalerts = True after this -----Original Message----- I don't see this option in saveas. Is there another way to avoid the overwite dialog box when overwriting a file with a macro? Thanks . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to run a macro automatically when the file is opened? | Excel Discussion (Misc queries) | |||
| insert rows automatically to avoid overwriting | Excel Discussion (Misc queries) | |||
| Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
| saveas CSV file | Excel Discussion (Misc queries) | |||
| Automatically run macro when opening file | Excel Programming | |||
Linear Mode
