Re: In todays world pdf is an important format BUT adobe makes our lifes complicated...

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

Thank you Harlan,

well for whom ever desired to know how to accomplish what it was i
wanted to accomplish with pdfmaker 5 I have found a way to bypass the
annoying popup. Yes its more steps but it works, makes me feel good
that it works and makes my boss happy there for im happy :)

heres some code for all of you.

Dim GenericReportPsFile As String
Dim GenericReportPdfFile As String

GenericReportPsFile = Application.ActiveWorkbook.Path & "\"
& GenericReportTitle & ".ps"
GenericReportPdfFile = Application.ActiveWorkbook.Path &
"\" & GenericReportTitle & ".pdf"

' Get active printer.
strActivePrinter = Application.ActivePrinter
' Change to the Microsoft Fax printer driver.
'Application.ActivePrinter = "Acrobat PDFWriter on LPT1:"
Application.ActivePrinter = "Acrobat Distiller on Ne01:"
' Print the active document
Selection.PrintOut Copies:=1, printtofile:=True,
prtofilename:=GenericReportPsFile

Dim myPDF As PdfDistiller
Set myPDF = New PdfDistiller
myPDF.FileToPDF GenericReportPsFile, GenericReportPdfFile,
""

' Change back to the default printer.
Application.ActivePrinter = strActivePrinter

Kill GenericReportPsFile

You must include in your references the distiller object.

so you have to print to post script then convert to pdf using
distiller.

now I am looking to figure out how to append to pdf files or to ps
files so that i can add more than one report to my pdf.

Thank You all for your answers.

.

Relevant Pages

  • Converting an Encrypted PDF to Image
    ... PDF files. ... decrypt it and create the imageof that page. ... I am looking at a free "Java" library to accomplish this. ...
    (comp.lang.java.security)
  • Re: Xaviers Book
    ... Couldn't they just sell the PDF of the book, ... What this would accomplish is people in ... electronic + print on demand, ... I guess the problem with electronic shipping is file sharing, ...
    (borland.public.delphi.non-technical)
  • Re: a customer made this beautiful flyer, and I was wondering if someone
    ... >could tell me how to accomplish the sideways printing, and the 'ghost" ... If you did attach a PDF to your article, ...
    (comp.graphics.apps.photoshop)
  • Controlling Acrobat with VBA
    ... Here is what I am trying to accomplish. ... attachments which are linked to the database in a OLE field in PDF ... the user adds it using the insert header function in PDF. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using VBA to open PDF
    ... FollowHyperlink should cause any fiele (including PDF) to open in the ... rather than allenbrowne at mvps dot org. ... >I have an option group with a 6 or 8 options. ... >able to accomplish this with Word and Excel documents however am having a ...
    (microsoft.public.access.forms)