Sub Export_PDF()
Dim ChNomFic As Variant
ChDir "C:\Base\Laval"
ChNomFic = Application.GetSaveAsFilename("", "Fichier PDF,*.pdf")
If VarType(ChNomFic) <> vbString Then Exit Sub
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ChNomFic, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub