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"