Save Macro Template on a network drive as Excel file using a cell value as the name

[rjagain62]

I've had 2 suggestions that I can't get to work on Excel 2014.
A couple other people have told me it can't be done.
Range E5 would be the file name ( It's a quote number ).

Sub Save_Me()
'
' Save Me Macro
'

'
ActiveWorkbook.SaveCopyAs Filename:="F:\GP SAVED BY RICH\" & Range("E5").Value & ".xlsm"
End Sub

And this one

Sub Save_Me()
'
' Save Me Macro
'

'
ActiveWorkbook.SaveAs Filename:="F:\GP SAVED BY RICH\" & Range("E5").Value, FileFormat:=52

Your opinions are valued.