Re: Print on PDF file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gord Dibben (gorddibbATshawDOTca)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 10:02:07 -0800

Michael mentions Ghostscript.

I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.

The use of Ghostscript is the key point with this method.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 22:16:57 +1000, Michael Bednarek <ROT13-zo@zorqanerx.pbz>
wrote:

>On Mon, 27 Dec 2004 09:14:19 +0100, "Thanos"
><thanos.aNOSPAM@fastwebnet.it> wrote in
>microsoft.public.excel.programming:
>
>>is there anyone who knows how to create a PDF file of the active worksheet
>>through VBA code ?
>>I tried many examples found on the net with no success...
>
>If you have full Acrobat (not just the Reader), you can use several
>methods:
>
>1) Set the active printer to Distiller and simply use the method
>.Printout - from memory, that will present a problem regarding the
>filename selection
>
>2) Adobe Distiller provides its own print method: FileToPDF.
>
>If you don't have full Acrobat, you could use Ghostscript and RedMon.
>Then you have to manipulate the RedMon registry entry which holds the
>output filename. This will involve some nasty registry read/write
>actions and dealings with the obscure way Excel uses printer names and
>ports (different to any other MS Office application).
>
>I have implemented the latter here, where a macro prints a number of
>spreadsheets (>10) rapidly to PDF files (saving paper). However, about
>once a week that process plays havoc with one particular PC's display:
>no refresh in any window -including TaskMgr-, completely nuts.
>
>Like you, I'm looking for a stable add-on which will provide the
>equivalent to Adobe's FileToPDF; the full Acrobat is just to expensive
>for that. The radical alternative, OpenOffice or Quattro, which both
>provide native PDF output, is unfortunately not practical for us. It
>might be for you, though.
>
>Let us know if you find anything.

Relevant Pages

  • Re: text messes up in ps2pdf converted pdf
    ... that somehow the ordering of the text is preserved in the pdf file, ... current version opf GS and opened with Acrobat 9.0. ... So Ghostscript is the real "worker" doing the con- ... used are Type3 fonts using a custom "encoding". ...
    (comp.lang.postscript)
  • Gradient bug in gs8.51 (or in PDF file ?)
    ... Acrobat 6 and Photoshop CS seem perfectly happy with the file. ... I could use to check the conformance of the PDF file. ... Maybe somebody on the Ghostscript ...
    (comp.text.pdf)
  • color problem with epstopdf
    ... GhostScript changed its use of color models. ... Between 7.04 and 8.53 the handling of color spaces in PDF output ... file specified a CMYK color, then the output PDF file contains ... and dvips to a pretty PDF file with no problem. ...
    (comp.text.tex)
  • Re: Free Ruby eBook
    ... Ghostscript than a PDF viewer, it is trivial to convert a PDF file to ... postscript by just "printing" to a postscript printer and saving the ...
    (comp.programming)
  • How can i use CID fonts in GhostScript?
    ... I'm using Ghostscript to print a pdf file containing CID fonts,but it ... Substituting font Times-Roman for TimesNewRoman. ... Substituting CID font resource/Adobe-GB1 for /SimSun. ...
    (comp.lang.postscript)