Sub Macro1Bis()
Dim NomFic$, Chemin$
Chemin = "C:\Temp\"
NomFic = InputBox("Saisir le nom du PDF désiré" & Chr(13) & "(extension comprise)", _
"EXPORT PDF", Replace(ActiveWorkbook.Name, ".xlsm", ".pdf"))
Range("A1:G44").ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=Chemin & NomFic, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub