1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
Sub ImprimerEnPdf()
Dim AireOnglets As Range, AireAdresses As Range, AireNomPdf As Range, AireAImprimer As Range
Dim I As Long
Dim OngletChoisi As String, RepertoireFichiersPdf As String, CheminComplet As String
OngletChoisi = Sheets("Paramètres").Range("NomDeLOnglet")
RepertoireFichiersPdf = ActiveWorkbook.Path & "\Fichiers pdf\"
Set AireOnglets = Range("TableDesZones[Onglets]")
Set AireAdresses = Range("TableDesZones[Adresses]")
Set AireNomPdf = Range("TableDesZones[Nom des fichiers pdf]")
For I = 1 To AireOnglets.Count
With AireOnglets(I)
If .Value = OngletChoisi Then
CheminComplet = RepertoireFichiersPdf & AireNomPdf(I) & " " & Gdh
Set AireAImprimer = Sheets(AireOnglets(I).Value).Range(AireAdresses(I).Value)
AireAImprimer.ExportAsFixedFormat Type:=xlTypePDF, Filename:=CheminComplet & ".pdf", _
quality:=xlQualityStandard, includedocproperties:=True, _
ignoreprintareas:=False, openafterpublish:=False
Set AireAImprimer = Nothing
End If
End With
Next I
Set AireOnglets = Nothing: Set AireAdresses = Nothing: Set AireNomPdf = Nothing
End Sub
Function Gdh() As String
Dim DateExport As String, HeureExport As String
Dim TableDate As Variant, TableHeure As Variant
TableDate = Split(CStr(Date), "/")
DateExport = TableDate(2) & "-" & TableDate(1) & "-" & TableDate(0)
TableHeure = Split(CStr(Time), ":")
HeureExport = TableHeure(0) & TableHeure(1) & TableHeure(2)
Gdh = DateExport & " " & HeureExport
End Function |
Partager