View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wayne Huxman Wayne Huxman is offline
external usenet poster
 
Posts: 3
Default 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