Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code to save a file.
ActiveWorkbook.SaveAs FileName:=fs_Path & "Data\" & ls_SmallSaveName & ".xls", FileFormat:= _ xlNormal, Password:="", writerespassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False A dialog box comes up if the file already exists asking whether to replace it. How can I handle it if the user says 'No'? Thanks, Dale |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA SaveAs Value | Excel Discussion (Misc queries) | |||
SaveAs | Excel Worksheet Functions | |||
Help with saveas | Excel Programming | |||
SaveAs | Excel Programming | |||
SaveAs | Excel Programming |