Sub pdfcrewchange()
Dim Chemin As String, NomFichier As String
Range("AA13") = Range("AA13") + 1 'valeur de la cellule incrémenter de 1
NomFichier = "Crew change " & Range("P7").Value & " - V" & Range("AA13") & ".pdf"
With Application.FileDialog(msoFileDialogFolderPicker)
If .Show = -1 Then ' Clic sur Ok
Chemin = .SelectedItems(1)
Else
' Clic sur Annuler
Exit Sub
End If
End With
Sheets("Crew change").ExportAsFixedFormat Type:=xlTypePDF, Filename:=Chemin & "\" & NomFichier, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub