Re: Use VBA to Print a PostScript Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SA (~fake.address_at_nspm.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 05:58:43 -0400

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. 

-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Tony_VBACoder" <anonymous@discussions.microsoft.com> wrote in message 
news:c8a001c48a5d$14506060$a501280a@phx.gbl...
> 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.

Relevant Pages

  • Re: Converting Power Point to PDF
    ... versions of Acrobat on a single PC. ... Next dialog box says Creating ADobe PDF. ... Both methods use an add-in that's installed into PPT, Excel, Word etc. ... Open a presentation in PowerPoint ...
    (microsoft.public.powerpoint)
  • Re: Acrobat Professional V7 and Office/Word 2003
    ... > including "Adobe PDF". ... there is the suggestion "Solution 12: Remove Microsoft Works". ... Works installed, but not the add-in, and the Acrobat menus now appear ...
    (comp.text.pdf)
  • Re: Word & Acrobat
    ... It says "Adobe PDF" as a printer. ... Jeremy ... Adobe Acrobat and often convert Word documents into PDF ...
    (microsoft.public.word.application.errors)
  • Re: pdf maker missing from Word
    ... I should have mentioned that I am on Acrobat 6. ... I can create PDF's successfully by printing to the Adobe PDF ... "Graham Mayor" wrote: ... > Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.customization.menustoolbars)
  • RE: How do I save Word as an Adobe Document?
    ... Open the Printer Name list at the top and choose Adobe PDF or Acrobat ... Distiller (depending on version). ...
    (microsoft.public.word.docmanagement)