Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone please advise me about the correct operation of SaveCopyAs.
I am using it as follows: MsgBox Application.DisplayAlerts MsgBox ActiveWorkbook.Path & "\_new\" & ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs ActiveWorkbook.Path & "\_new\" & ActiveWorkbook.Name So DisplayAlerts is True, yet I get no warning when the SaveCopyAs overwrites the existing (pre-saved) file. Is this by design, or am I missing something here. Coding in a FileExists check is no problem, but I would have thought that ANY save operation would give an overwrite warning by default. Regards, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Savecopyas without password | Excel Discussion (Misc queries) | |||
SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
SaveCopyAs macro | Excel Programming | |||
SaveCopyAs - Userform disappears | Excel Programming |