I have VB Code handling the save as function of a form. When the form already exists it comes up and asks if you want to overwrite it and if you say yes, it does, if you say no, it doesn't. however I have a mesage Box come up afterwards that lets you know that it was saved and where. However, that message box comes up even if you select no.
I am assuming it is an if statement to accomplish this but I am not really sure how to write it. I want it to say it wasn't saved if they click no and that it is saved if they click yes.
ActiveWorkbook.SaveAs Filename:="AR" + "_" + x + "_" + y, _
FileFormat:=xlNormal
Message = "Your Activity Report has been saved in your 'My Documents' folder."
MsgBox (Message)
Any help would be great!!
Sean