Bonjour,
J'ai plusieurs feuille excel qui s'enregistre dans plusieurs documents PDF quand je clique sur un bouton,
Par contre ce que je voudrais faire:
enregistrer ces feuille dans un seul et unique document PDF
Voici ma formule actuelle:
Private Sub CommandButton1_Click()
'
' Macropdf Macro
'
Sheets("planning").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\" & Environ("username") & "\Dropbox\Planning Mauridul\Arriver.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
Sheets("planning Payement").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\" & Environ("username") & "\Dropbox\Planning Mauridul\Payement.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
Sheets("Calendrier 2").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\" & Environ("username") & "\Dropbox\Planning Mauridul\Calendrier.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
Sheets("Calendrier 3").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\" & Environ("username") & "\Dropbox\Planning Mauridul\Calendrier suite.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
End Sub
Merci d'avance au pro de votre aide précieuse,
Salutation Ambroise