B
broogle
Hi, I am running a code
ActiveWorkbook.SaveCopyAs Filename:= _
"C:\Temp" & "\" & Range("c10") & Range("c7") & ".xls"
Unfortunatelly, everytime I run it, it will override the previous file
without saying that the file name already exist. Tried to use
Application.DisplayAlerts = True, it didn't work. Any idea ?
Thanks
ActiveWorkbook.SaveCopyAs Filename:= _
"C:\Temp" & "\" & Range("c10") & Range("c7") & ".xls"
Unfortunatelly, everytime I run it, it will override the previous file
without saying that the file name already exist. Tried to use
Application.DisplayAlerts = True, it didn't work. Any idea ?
Thanks