Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum issue Tim Hill[_2_] Excel Worksheet Functions 1 October 14th 08 06:20 PM
PrintToFile from spreadsheet juzek Excel Programming 0 June 28th 06 10:39 PM
PrintToFile OutputFilename problems Brent Burkart Excel Programming 4 June 14th 04 05:30 PM
PrintToFile param - what's the file format? jstrater Excel Programming 3 May 16th 04 10:09 PM
VBE Issue Seth[_5_] Excel Programming 1 November 15th 03 09:35 AM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"