RE,
Une nouvelle proposition :
Public Sub Enregistrer_sous()
Dim ws As Worksheet
Dim sDate As String, sFile As String
Const sPATH As String = "S:\Desk_Credit\Primaire\TCA\"
With ActiveWorkbook
Set ws = .Worksheets("Main")
sDate = Format(ws.Range("AB1"), "YYYYMMDD HHMM")
sFile = "Quotes at " & sDate & ".xlsx"
.SaveAs Filename:=sPATH & sFile, FileFormat:=51
End With
End Sub