I have been using the following file SaveAs process, but recently found that when saving if someone else has the file open, it fails. How would I add a time stamp to the file save as to prevent this from happening? I have some cases were I was overwritting the previous file with the new current file, but see that is not going to work.
Dim FName As String
FName = "W:\Holland\rrw5\Bruce Shortage Report "
FName = FName & Format(Date, "ddmmmyy") & ".xlsx"
ActiveWorkbook.SaveAs Filename:= _
FName, FileFormat:= _
MsgBox ("File Saved to " & FName)