Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

log file getting created when converting .xls to .pdf

Status
Not open for further replies.

chemburkar

Programmer
Nov 14, 2003
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top