I am using Adobe Acrobat v 5.0/6.0 and have both the PDFWriter and Distller print drivers available. I am generating the PDF document out of VFP using wwPDF just fine.

The objective is to drive Excel from VFP and to generate a PDF report to a specific directory with a specific filename without dialog boxes. I am testing using an Excel macro and notice that DISTILLER generates a PostScript print file format, while PDFWriter generates a real PDF. The postscript PDF from DISTILLER is not recognized by Adobe which generates a 'file corrupted' message on opening. The VBA macro being used is:

Public Sub PDF_IT()

ActiveWindow.SelectedSheets.PrintOut Copies:=1, _
ActivePrinter:="Acrobat Distiller", Collate:=True, _
Printtofile:=True, PrToFileName:="XL_PrntFileName.pdf"

End Sub

When the ActivePrinter is defined as "Acrobat PDFWriter", the output PDF works just fine. The target directory is defined in Printers/Properties/Ports, PORT column value.

The questions are:

(1) does DISTILLER *always* generate a postscript file or am I missing something in the macro?

(2) what is the advantage of DISTILLER over PDFWriter?

(3) Is there another method to be used to print from BOTH VFP and Excel to PDF formats?

Thanks