Printing Reports to Adobe PDF Writer

[E Jordan]

Hi,

I wish to develop a macro (or VBA script) that can change
report criteria (allowing one "Service Line" to be printed
at a time); automatically select the Adobe PDF writer as
the printer; and has the ability to select a file location
and populate the name for the PDF document.

Currently, I have a macro that will automatically modify
the report criteria and print, however, I am unable to
specify a specific printer with the macro and I cannot
automate the naming process. Any help is greatly
appreciated.

 

[Steve Schapel]

E,

I don't think this can be done with a macro.

There is some sample VBA code at
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
for switching default printers.

I have used PDF995 which has some options to specify file names.
http://www.pdf995.com

- Steve Schapel, Microsoft Access MVP