1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Sub Rectangle2_Cliquer()
'export de la facture en pdf
info1 = Sheets("FACTURE").Range("F6")
info2 = Sheets("FACTURE").Range("F4")
info3 = Sheets("FACTURE").Range("G3")
Nom = info1 & " " & info2 & " " & info3 & " " & ".xls"
ThisWorkbook.Save
ThisWorkbook.SaveAs (Nom)
ThisWorkbook.Activate
If MsgBox("Avez vous terminer votre facture ?", vbYesNo, "L'application vous informe") = vbYes Then
ChDir "/Bureau/Mesfactures/"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, quality:= _
xlQualityStandard, incluseDocproperties:=True, ignoreprintareas:=False, _
from:=1, to:=1, openafterpublish:=True
End If
End Sub |
Partager