Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel PDF Printing - PDFWriter .vs. Distiller
Message
 
To
08/03/2004 12:45:26
Doug Sherman
Douglas Sherman Consulting
Littleton, Colorado, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00884150
Message ID:
00886600
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform