Sub Confirmer_Commande_Envoi()
Dim NFic$, strPath As String
strPath = ThisWorkbook.Path & "\"
NFic = Format(Date, "yyyymmdd") & " BBcommande de matériel médical chez Mediq.pdf"
With Sheets("commande (envoi)")
.Range("$A$4:$K$300").AutoFilter Field:=5, Criteria1:="<>Mediq"
.Range("$A$4:$K$300").AutoFilter Field:=10, Criteria1:="<>"
.Columns("H:I").EntireColumn.Hidden = True
.AutoFilter.Range.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=srPath & NFic, Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
.ShowAllData
.Columns("H:I").EntireColumn.Hidden = False
.AutoFilterMode = False
End With
End Sub