Macro to save in current location

[Ian1976]

hi all,

I'm after some help please, I'd like a macro that when pressed via a cmd button will save my workbook using the text in cell J1 and N1 and then add the current date which is in cell L1,and if possible to be saved in the current location!

Thanks!

 

[Fluff]

How about

Sub Ian1976()
   Dim Fname As String
   
   Fname = Range("J1") & Range("N1") & Format(Range("L1"), "dd-mm-yyyy")
   ThisWorkbook.SaveAs ThisWorkbook.path & "\" & Fname & ".xlsm", 52
End Sub

 

[Ian1976]

Thank you Fluff works lovely! How can I add a space between N1 & L1?

 

[Fluff]

Like

   Fname = Range("J1") & Range("N1") &[COLOR=#ff0000] " " &[/COLOR] Format(Range("L1"), "dd-mm-yyyy")

 

[Ian1976]

Thank you Fluff! ??

 

[Fluff]

You're welcome & thanks for the feedback