Re: PDF Save As problem
From: Trexx (foo_at_foo.com)
Date: 10/29/04
- Next message: $600b decifit by Jan 2005, then $800 with Iran+N.Korea: "Re: How do I get an OLEObjects check box to call a function when click"
- Previous message: Shilps: "Re: Fecthing comment text"
- In reply to: lance99: "PDF Save As problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 04:39:07 GMT
lance99
this is extracted from the comp.lang.rexx newsgroup...from Lee Peedin. Note
this won't work with Distiller 4.0, but
appears to work with Distriller 6.0
There are 2 things necessary to make the Adobe Distiller "automatic".
1) Open the Properties for the Adobe Distiller (in your printers
folder)
On the General Tab click Printing Preferences
Remove the check by "Prompt For Adobe PDF filename"
(this is what prompted for the file name)
Remove the check by "View Adobe PDF results"
(this is what opened the PDF reader after the file was created)
2) Go back to the Properties and select the "Ports" tab
Select the "Add Port" button
You will see a list of port types
Select Adobe PDF Port and click New Port
At that point you will be shown a dialog of folders accessible on
your system, select the folder you wish the PDF files to be saved in.
T-Rex
"lance99" <lance99@discussions.microsoft.com> wrote in message
news:34C904A3-B25B-400A-951C-3330A58E9B8F@microsoft.com...
> I have been searching days for a solution to this problem. I am using
Excel
> 2002 with Adobe 6.0 to create reports. I know all the different routes to
> take: print to file as .ps and then convert, using the distiller, but I am
> using the
>
> Application.ActivePrinter = "Adobe PDF on Ne00:"
> ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
> "Adobe PDF on Ne00:", Collate:=True
>
> Which then brings up a Save As prompt. I am trying to send the filename
to
> the box via vba. I have tried the SendKeys function which I have used in
> other code for basically the same purpose but it doesn't work.
>
> Does anyone have a solution for this, if so it would be greatly
appreciated.
>
> Thanks
>
>
>
> --
> Keep it real up in the field, aaaaright
- Next message: $600b decifit by Jan 2005, then $800 with Iran+N.Korea: "Re: How do I get an OLEObjects check box to call a function when click"
- Previous message: Shilps: "Re: Fecthing comment text"
- In reply to: lance99: "PDF Save As problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|