chemburkar
Programmer
Hi,
I am creating pdf file from excel file using VBA code
Here is the sample VBA code
Dim PdfDistillerObj As Object
'create object using distiller dll
Set PdfDistillerObj = CreateObject("PdfDistiller.PdfDistiller.1"
' create the pdf report from the ps report.
PdfDistillerObj.FileToPDF strMenuFilePS, ReportFileName, ""
Set PdfDistillerObj = Nothing
How do I set the Distiller's option "Delete Log Files for successful jobs" in the above case?
Right now above code creates log file along with the pdf file (which is deafult setting of distiller)
Thanks in advance
I am creating pdf file from excel file using VBA code
Here is the sample VBA code
Dim PdfDistillerObj As Object
'create object using distiller dll
Set PdfDistillerObj = CreateObject("PdfDistiller.PdfDistiller.1"
' create the pdf report from the ps report.
PdfDistillerObj.FileToPDF strMenuFilePS, ReportFileName, ""
Set PdfDistillerObj = Nothing
How do I set the Distiller's option "Delete Log Files for successful jobs" in the above case?
Right now above code creates log file along with the pdf file (which is deafult setting of distiller)
Thanks in advance