ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PrintToFile - PDF Issue (https://www.excelbanter.com/excel-programming/366660-printtofile-pdf-issue.html)

Wayne Huxman

PrintToFile - PDF Issue
 
I've been trying to automate a process to print a series of PDF files. The
code below generates the file, but the file is courrupted in some way and
won't open in Acrobat. I change the "Do not sent fonts" option for the
Acrobat Distiller to false. I also tried taking the references to the
distiller out of the code. I'm sure it must be possible and suspect there
may be other Distiller options that may need to be changed. Any tipes would
be greatly appreciated.


Code:
Application.ActivePrinter = "Acrobat Distiller on Ne01:"

ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Acrobat Distiller on Ne01:", PrintToFile:=True, Collate:=True, _
PrToFileName:=PrFile

Sincerely,

Wayne




All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com