Access and Adobe Distiller

[xzzy]

I have been tasked with changing the filename Adobe Distiller defaults to.
My guess is I can't change it. Has anyone been able to use VBA to change
that name?

Thanks,

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

[James Neumann]

John,

In the past, I have found it best to manually create another port, and
set Distiller to print to a specific directory of your choice. I do
this through Settings_Printers, right-click to bring up server
properties, and on the "Ports" tab add a new port (This is in W2K
Workstation). If you have Distiller installed, one of the options
will be "PDFPort", and you can specify where this will be. You should
be able to do this in VB/VBA, I just have NFC as to how.

I did spend about a half-day once trying to change the default, and
gave up. I suspect the solution will involve finding the registry
key, and resetting it to the value you want. There are probably
several places it needs to be changed, as I could never get it to work
properly. Adobe's site wasn't all that helpful, but this was about a
year ago, so that may have changed.

HTH,

JCN

"xzzy" <mr********@comcast.net> wrote in message news:<B0pKb.137879$VB2.497866@attbi_s51>...

I have been tasked with changing the filename Adobe Distiller defaults to.
My guess is I can't change it. Has anyone been able to use VBA to change
that name?

Thanks,

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

[xzzy]

thank you for your help, if I figure out a solution, I'll post to this NG

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"James Neumann" <bo*********@hotmail.com> wrote in message
news:77**************************@posting.google.c om...

John,

In the past, I have found it best to manually create another port, and
set Distiller to print to a specific directory of your choice. I do
this through Settings_Printers, right-click to bring up server
properties, and on the "Ports" tab add a new port (This is in W2K
Workstation). If you have Distiller installed, one of the options
will be "PDFPort", and you can specify where this will be. You should
be able to do this in VB/VBA, I just have NFC as to how.

I did spend about a half-day once trying to change the default, and
gave up. I suspect the solution will involve finding the registry
key, and resetting it to the value you want. There are probably
several places it needs to be changed, as I could never get it to work
properly. Adobe's site wasn't all that helpful, but this was about a
year ago, so that may have changed.

HTH,

JCN

"xzzy" <mr********@comcast.net> wrote in message

news:<B0pKb.137879$VB2.497866@attbi_s51>...

I have been tasked with changing the filename Adobe Distiller defaults to. My guess is I can't change it. Has anyone been able to use VBA to change that name?

Thanks,

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

[Tony Toews]

"xzzy" <mr********@comcast.net> wrote:

I have been tasked with changing the filename Adobe Distiller defaults to.
My guess is I can't change it. Has anyone been able to use VBA to change
that name?

I'm not online right now so I can't check but see the "Automated Creation of a PDF
Document from Microsoft Excel" link at the PDF page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Ryan]

How about printing to the file it wants to and then move/rename the
file as you want afterwards ? Have a look at FileSystemObjects in VBA
as these should make the task quite easy.

"xzzy" <mr********@comcast.net> wrote in message news:<B0pKb.137879$VB2.497866@attbi_s51>...

I have been tasked with changing the filename Adobe Distiller defaults to.
My guess is I can't change it. Has anyone been able to use VBA to change
that name?

Thanks,

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com