Dim JobPDF As Object
Dim sNomPDF As String
Dim sCheminPDF As String
If IsEmpty(Feuil12.UsedRange) Then Exit Sub
sNomPDF = Feuil12.Range("C17")
sCheminPDF = "C:\Documents and settings\GREG\Bureau\COMMANDES\"
Set JobPDF = CreateObject("PDFCreator.clsPDFCreator")
With JobPDF
If .cStart("/NoProcessingAtStartup") = False Then
MsgBox "Initialisation de PDFCreator impossible", vbCritical + vbOKOnly, "PDFCreator"
Exit Sub
End If
.cOption("UseAutosave") = 1
.cOption("UseAutosaveDirectory") = 1
.cOption("AutosaveDirectory") = sCheminPDF
.cOption("AutosaveFilename") = sNomPDF
.cOption("AutosaveFormat") = 0
.cClearCache
End With
Feuil12.PrintOut Copies:=1, ActivePrinter:="PDFCreator"
Do Until JobPDF.cCountOfPrintjobs = 1
DoEvents
Loop
JobPDF.cPrinterStop = False
Do Until JobPDF.cCountOfPrintjobs = 0
DoEvents
Loop
JobPDF.cClose
Set JobPDF = Nothing
MsgBox "Commande éditée", vbInformation, "COMMANDE"
End If
Next
End With