Thread: Saveas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale Levesque Dale Levesque is offline
external usenet poster
 
Posts: 4
Default Saveas

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