Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum issue | Excel Worksheet Functions | |||
PrintToFile from spreadsheet | Excel Programming | |||
PrintToFile OutputFilename problems | Excel Programming | |||
PrintToFile param - what's the file format? | Excel Programming | |||
VBE Issue | Excel Programming |