Thanks, Ron, I would appreciate your insight Distiller and PDFWriter for printing to a file out of Excel. I plan to drive Excel from VFP via COM, but have used an Excel macro during the prototyping.

I also found that if I specify the full pathname (vol:\directories\filename) in the PrToFileName value, it works and Excel/Adobe writes the file there.

The VFP report is not large (2 pages) and the Excel graphs can range from 1 page to 4 pages depending on the option selected.

Doug Sherman

>Doug,
>
>I can show you how to get Distiller into gear. It takes some (minor) adjustments. The biggest advantages to use Distiller:
>- you can set security
>- pdf's are more compact
>- better support for foreign languages (like Polish etc)
>
>Let me know in you need any help.
>
>Regards,
>
>Ron
>
>>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