I have 40 reports that I would like to print with Adobe
Acrobat using Distiller. I can generate the file name in
the macro. Is there any way that I can pass it to Adobe so
that it can run on its own? Thanks in advance.

Ray Kanner

Are you saying you don't want to use the PDFWriter print driver?



--
Regards,
Tom Ogilvy

Ray Kanner wrote in message
...
I have 40 reports that I would like to print with Adobe
Acrobat using Distiller. I can generate the file name in
the macro. Is there any way that I can pass it to Adobe so
that it can run on its own? Thanks in advance.

Ray Kanner

Tom, It just so happens that PDFWriter doesn't print out
as well as Distiller does, but unless I'm missing
something the interface that the user sees is more or less
the same. Whether I'm using the PDFWriter driver or the
Distiller driver, whichever the printer is pointing to,
the user is asked for the name of the file that it
should "write" to, although it is presented with a default
name. Since I am running many of these reports, I would
like to pass a name from my code to it so that it happens
automatically and I don't have to manually respond each
time. Thanks in advance.

Ray
-----Original Message-----
Are you saying you don't want to use the PDFWriter print
driver?



--
Regards,
Tom Ogilvy

Ray Kanner wrote in message
...
I have 40 reports that I would like to print with Adobe
Acrobat using Distiller. I can generate the file name in
the macro. Is there any way that I can pass it to Adobe
so
that it can run on its own? Thanks in advance.

Ray Kanner


.

In excel 2000 and later, you should be able to supply the filename as part
of the printout command. Whether it works with your driver or not, I can't
say, but I would expect it would.

there has been a lot of discussion in the past on creating PDF's. Perhaps
you can check the archives through google groups:

http://groups.google.com/advanced_group_search?hl=en


--
Regards,
Tom Ogilvy

Ray Kanner wrote in message
...
Tom, It just so happens that PDFWriter doesn't print out
as well as Distiller does, but unless I'm missing
something the interface that the user sees is more or less
the same. Whether I'm using the PDFWriter driver or the
Distiller driver, whichever the printer is pointing to,
the user is asked for the name of the file that it
should "write" to, although it is presented with a default
name. Since I am running many of these reports, I would
like to pass a name from my code to it so that it happens
automatically and I don't have to manually respond each
time. Thanks in advance.

Ray
-----Original Message-----
Are you saying you don't want to use the PDFWriter print
driver?



--
Regards,
Tom Ogilvy

Ray Kanner wrote in message
...
I have 40 reports that I would like to print with Adobe
Acrobat using Distiller. I can generate the file name in
the macro. Is there any way that I can pass it to Adobe
so
that it can run on its own? Thanks in advance.

Ray Kanner


.