ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing using Acrobat (https://www.excelbanter.com/excel-programming/286217-printing-using-acrobat.html)

Ray Kanner[_2_]

Printing using Acrobat
 
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 Ogilvy

Printing using Acrobat
 
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




Ray Kanner[_2_]

Printing using Acrobat
 
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



.


Tom Ogilvy

Printing using Acrobat
 
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



.





All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com