I have a worksheet that reads data from a lookup table ... it then needs to
create a pdf file with a specific name based on data that is read from the
lookup table. This process would then continue until all lookup values are
exhausted.

How do I pass the correct filename onto Acrobat 6.0 so this worksheet would
not require any user input on the filenames? I know how to assemble the
filename but am having problems passing it to Acrobat.

Thanks!

Roedd <<CraigCC wedi ysgrifennu:

I have a worksheet that reads data from a lookup table ... it then
needs to create a pdf file with a specific name based on data that is
read from the lookup table. This process would then continue until
all lookup values are exhausted.

How do I pass the correct filename onto Acrobat 6.0 so this
worksheet would not require any user input on the filenames? I know
how to assemble the filename but am having problems passing it to
Acrobat.

Are you using the acrobat print driver to create the PDF file? If so you can
pass the filename via a registry setting (or you could when I did this a few
versions of Acrobat back). Post back if you need code.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

Yes I am using the Adobe Printer Driver. Could you share your registry code?

"Robert Bruce" wrote:

Roedd <<CraigCC wedi ysgrifennu:

I have a worksheet that reads data from a lookup table ... it then
needs to create a pdf file with a specific name based on data that is
read from the lookup table. This process would then continue until
all lookup values are exhausted.

How do I pass the correct filename onto Acrobat 6.0 so this
worksheet would not require any user input on the filenames? I know
how to assemble the filename but am having problems passing it to
Acrobat.

Are you using the acrobat print driver to create the PDF file? If so you can
pass the filename via a registry setting (or you could when I did this a few
versions of Acrobat back). Post back if you need code.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

Roedd <<CraigCC wedi ysgrifennu:

Yes I am using the Adobe Printer Driver. Could you share your
registry code?


See my post he http://tinyurl.com/at7se

Full URL
http://groups.google.co.uk/group/mic...:bruce& hl=en

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

On Thu, 2 Jun 2005 18:21:02 -0700, "CraigCC"
wrote in
microsoft.public.excel.programming:

I have a worksheet that reads data from a lookup table ... it then needs to
create a pdf file with a specific name based on data that is read from the
lookup table. This process would then continue until all lookup values are
exhausted.

How do I pass the correct filename onto Acrobat 6.0 so this worksheet would
not require any user input on the filenames? I know how to assemble the
filename but am having problems passing it to Acrobat.

Establish a reference to Acrobat Distiller (acrodist.exe) and use the
PDFDistiller method .FileToPDF - after you printed your document as a PS
file to the Acrobat Distiller printer - no messing with the Registry.

For coding details, search the Internet for "filetopdf VBA"; I showed
some code fragments in
<http://groups.google.com.au/group/microsoft.public.access/browse_frm/thread/233394b566500b71/73a70a6ee8868107&rnum=2&hl=en#73a70a6ee8868107,
Message-ID: ,
Date: Mon, 21 Feb 2005 01:10:16 +1000.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"