Hello everyone,
In my Excel VBA code I have the following statement to save the active workbook -
ActiveWorkbook.SaveAs Filename:= _
"\\Fs3\is\Project_Management\Time_Tracking\" & lanid & " " & Format(Date, "MMDDYYYY") & ".xls"
If there is a file that already exists at this location with the same name I get the prompt asking me do I want to save over the existing copy. If I click Yes it continues to the next step in the sub routine which is good. The problem is when I click No or Cancel it exits the sub routine.
I need to be able to say No or Cancel and it proceed to the next line of code.
Any help is greatly appreciated.
If I have been unclear, I apologize, please let me know what I need to provide.
Thanks!
In my Excel VBA code I have the following statement to save the active workbook -
ActiveWorkbook.SaveAs Filename:= _
"\\Fs3\is\Project_Management\Time_Tracking\" & lanid & " " & Format(Date, "MMDDYYYY") & ".xls"
If there is a file that already exists at this location with the same name I get the prompt asking me do I want to save over the existing copy. If I click Yes it continues to the next step in the sub routine which is good. The problem is when I click No or Cancel it exits the sub routine.
I need to be able to say No or Cancel and it proceed to the next line of code.
Any help is greatly appreciated.
If I have been unclear, I apologize, please let me know what I need to provide.
Thanks!