Specify pdf filename

[George]

I had a vision that it would be trivial to control the pdf
filename given to my output. So I bought Acrobat and
Distiller, and spent hours reviewing documentation.

Can anyone help me use VBA to tell Acrobat or Distiller
that I want my output to go to C:\Output\MyFile.pdf ?

Thank you for your help.

 

[Alex Dybenko]

dont know about Distiller, but you can output file to some default location
and then FileCopy it to location you need

 

[SA]

George:

Adobe does not provide any mechanism to do this using distiller unless you
start with a postscript print file. If you set up a postscript printer (any
ps compatible printer driver) to output to local port that is a file, then
you can use the Distiller com object to convert that file, once its created
to a pdf document.

On the other hand if you have Adobe already and want to simply automate
output of reports to specific files, then take a look at our PDF and Mail
Library for Access. You'll find it on our web.