VBA code to save as file with specific file name

Looking for code to save a file as a specific file name. For example, want file name to always contain the work DECO, followed by a space, followed by a job number.
Such as:
DECO 291131.xlsm

The job number is found in cell L5 in worksheet LOAD LIST. I have multiple worksheets.

Thank you!

Hello there,

Below is the code you would use. You would manually need to select the sheet and then run the macro below. Also, you will need to insert the beginning of your file path into where I have instructed below.

Let me know if you have any questions! Thanks!

Sub macro2()
Dim wbNew As Workbook

ActiveSheet.Select
ActiveSheet.Copy

Set wbNew = ActiveWorkbook
With wbNew
    ActiveWorkbook.SaveAs Filename:= _
     "your file path goes here" & Range("G4").Value & ".xlsm" _
    , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
    .Close
End With

End Sub

Wonderful! It worked. Thanks for the help!!

Helpful to me too, thanks.