VBA Printing Reports to File

  • Thread starter Thread starter Robbie Baquiran
  • Start date Start date
R

Robbie Baquiran

Hi All,

Would anyone happen to know how to set a printer to print to a file rather
than printing to physical pages? I'm having grief trying to automate the
creation of PDF's using the AdobeMakePDFforOffice library since it's not
really supported. I figured if I can at least get a post script file of the
report I want - I can use Distiller to create the PDF.

Any help is appreciated.

Thanks in Advance!

Robbie
 
You don't do it in code. Instead, add a new printer in Windows. In the Add
Printer Wizard, select Local printer and uncheck the Automatically detect
plug and play printers. In the port selection choose FILE: - you will be
prompted for a filename/location each time you print to this printer. Choose
the correct driver for whatever output you want, and name it something that
will remind you it is for Print to File. Set this printer to be the default
printer for your report.
 
Works like a charm Ron - Thanks a ton!


Ron Hinds said:
You don't do it in code. Instead, add a new printer in Windows. In the Add
Printer Wizard, select Local printer and uncheck the Automatically detect
plug and play printers. In the port selection choose FILE: - you will be
prompted for a filename/location each time you print to this printer.
Choose
the correct driver for whatever output you want, and name it something
that
will remind you it is for Print to File. Set this printer to be the
default
printer for your report.
Click to expand...
 
Back
Top