Use VBA to Print a PostScript Report

[Tony_VBACoder]

Using Access 2000, how can I use VBA code to print an
Access Report as a PostScript format? I have Adobe
Acrobat 6, and if I look in my Printers, I have one HP
Printer and a "Adobe PDF" printer installed. Where do I
find a PostScript printer? This is all needed in order to
convert the PostScript file to a PDF using the Acrobat
Distiller.

Thanks.

 

[SA]

Tony:

There is no VBA function or direct capability within Access to output a post
script file. You should note however, that the Acrobat 6 Adobe PDF printer
is essentially a system that DOES initially output a postscript file and
then uses Distiller (in the guise of the print process) to create the PDF
file. You can create a postscript file by printing to the Adobe PDF
printer and simply check the Print To File box in the print dialog.

If you want to automate the whole process you might stop by our web. We
have there two tools, one our PDF and Mail Library that supports automating
PDF output using Acorbat 6 and secondly our Print To File Manager that will
allow you to output a postscript file from any postscript printer (Adobe PDF
printer or the generic Adobe Post Script print files available on their web
or any other post script printer.) You'll find them in our developer tools
section.

 

[Tony_VBACoder]

Steve, thank you for the suggestion in this post and in my
other post "Print Access Report as PDF with Acrobat 6".
With regards to printing directly to the "Adobe PDF"
printer, is there a way to pass a "path and file name" to
the print process so that a file is automatically created
and saved? With Version 5, I used to set a Registry entry
in the <<HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter\PDFFileName>> key with the exact path and file
name and it would automatically get generated. The reason
I ask is, I will be creating a bunch of reports in a VBA
looping routine, where there will no user intervention
except the selection of the folder where the PDF file(s)
are to be created and stored.

With as much time as I have spent on this, I am about
ready to go back to Acrobat 5's PDF Writer.