By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,149 Members | 885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,149 IT Pros & Developers. It's quick & easy.

Access and Adobe Distiller

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
"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
Nov 12 '05 #4

P: n/a
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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.