I have removed the ribbon from my workbook and created a button that allows a user to save the document and subsequently exit excel. How would I modify this code to automatically save the document based on the values of two cells as follows:

"F2" - "F1" ... where as F2 is equal to a number, such as "1234"; and F1 is a name, such as "John Doe". In my example, I would want the macro to automatically save the document as "1234 - John Doe". The location of the saved document should be the same folder as the source of the template.

Thanks in advance for any help that comes my way! 


Sub saveandclose()

    Application.DisplayAlerts = False
    Application.Quit
    
End Sub