Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing to Acrobat 6.0 (XP)

    I have numerous print jobs from XL that I would like to print to a single PDF file (only one file and have multiple pages append to the file). Each time I try to print I am prompted to save a new PDF file.

    I have no need to save individual XL files and then use Acrobat's combining multiple files into one PDF file.

    Any suggetions would be appreciated.

    Thanks,
    John

  2. #2
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    When you select several workbooks, your printer probably sees separate jobs queued up. To make one file, you need to move all the worksheets to one workbook.
    1. <LI>Choose one workbook to be the "main/first" one. Activate the one you want to be second.
      <LI>Select all the worksheets in this "second" workbook.
      <LI>Right-click on a worksheet tab.
      <LI>Select Move or Copy...
      <LI>In the top drop-down, pick your "main" file to move to. Then in the second drop-down, select where you want to put these sheets -- usually added to the end.
    When you're done, you will have one big workbook to print. Be careful of the printer settings. If individual worksheets have different settings, that may pose a small problem in the final print job.

    Errol

  3. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    John

    Acrobat Distiller 6.0 has an option to append to pdf's which may also do the trick. I cannot give you more details at the moment because I'm having an Easter break <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> and ACrobat is at work.

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    Andrew,

    Have you had an opportunity to review how to append excel to pdfs. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

    Thanks,
    John

  5. #5
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> Oops - I reviewed, and I was wrong - your current method of appending is all there is AFAIK.
    .

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    After searching the internet I found the following code which will create a single PDF file. How would one tweak the code to append another print job to the same PDF file? Such as in the line of code "Sheets("Sheet2").........

    Example Code:

    Sub PDF_PostScript()
    ' Define the postscript and .pdf file names.
    Dim PSFileName As String
    Dim PDFFileName As String
    PSFileName = "c:myPostScript.ps"
    PDFFileName = "c:myPDF.pdf"

    ' Print the Excel range to the postscript file

    Sheets("Sheet1").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", printtofile:=True, collate:=True, _
    prtofilename:=PSFileName

    Sheets("Sheet2").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", printtofile:=True, collate:=True, _
    prtofilename:=PSFileName


    ' Convert the postscript file to .pdf
    Dim myPDF As PdfDistiller
    Set myPDF = New PdfDistiller
    myPDF.FileToPDF PSFileName, PDFFileName, ""

    Kill (PSFileName)

    End Sub

  7. #7
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    I assume from your question that you're not a VBA type by choice <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    That's a lovely routine you've found. I'd suggest that you fire up a dialog box to open one to many workbooks - this (untested) code does that and deals to sheet1 from each
    (you may need to be cleverer than this for the sheets). It wouldn't be hard to test for "any sheets with content" or other variations in an inner loop.
    -------------cut here ------------
    Sub PDF_PostScript()
    ' Define the postscript and .pdf file names.
    Dim PSFileName As String
    Dim PDFFileName As String
    PSFileName = "c:myPostScript.ps"
    PDFFileName = "c:myPDF.pdf"

    ' Print the first sheet of all workbooks to the postscript file

    With Application.FileDialog(msoFileDialogOpen)
    .AllowMultiSelect = True
    .Show
    If .SelectedItems.Count = 0 Then Exit Sub
    For I = 1 To .SelectedItems.Count
    Workbooks.Open FileName:=.SelectedItems(i), ReadOnly:=True
    Sheets("Sheet1").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", printtofile:=True, collate:=True, _
    prtofilename:=PSFileName
    ActiveWorkbook.Close savechanges:=False
    Next I
    End With

    ' Convert the postscript file to .pdf
    Dim myPDF As PdfDistiller
    Set myPDF = New PdfDistiller
    myPDF.FileToPDF PSFileName, PDFFileName, ""

    Kill (PSFileName)

    End Sub

  8. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    I may not be a VBA type by choice but I am determined.

    Here is a solution for creating a single PDF file from multiple postscript file utilizing Adobe's Rundirex.txt file. The basics to this file is that it takes all postscript files in a subdirectory and converts them to a single PDF file.

    Find the Rundirex.txt file on your computer. It most likely will be under: Eocuments and SettingsAll UsersDocumentsAdobe PDF 6.0Example Files. Create a new folder and place a copy of that file into the folder. Open the file in Notepad.

    The 7th line of code looks like this: /Pathname (Machintosh HD:Test:*.ps) def

    Change this line to indicate the path to the folder you just created. So if you created a folder called "C:PStoPDF", change the line to read:

    /Pathname (C:/PStoPDF/*.ps) def Yes, the slashes in the path are backwards, Acrobat wants them this way.

    Then save the Rundirex.txt as "filename.ps", where "filename" is the name you want for the final PDF file.

    In the code, create all of the PS files and place them into the folder (i.e., "PStoPDF") you created above.

    At the end of the code, distill only the "filename.ps" file. Acrobat will automatically execute the code in this file, which will look for any .ps files in the "PStoPDF" folder and create one PDF file from all of them.


    John

  9. #9
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    Hi john,

    We are getting more and more requests for pdf versions of our reports. I've reviewed this whole post and I think it contains the answers that we need. However, I'm unsure <img src=/S/confused.gif border=0 alt=confused width=15 height=20> about what bit of abode software would we need to do this?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing to Acrobat 6.0 (XP)

    The "official" Acrobat series of software from Adobe is good but pricy. There are cheaper, even free alternatives, see for example <post#=314690>post 314690</post#>. A search for free pdf in the Software Finds and Wants forum will turn up other possibilities.

  11. #11
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to Acrobat 6.0 (XP)

    Two questions, firstly ...

    Dim myPDF As PdfDistiller

    ... gives me a user defined type not available. Obviously missing a reference but I cannot see which one.

    Secondly,

    Sheets("Sheet1").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", printtofile:=True, collate:=True, _
    prtofilename:=PSFileName

    ... gives me a message from pdf saying "when you create a postscript file ... do not send fonts to distiller" I've unchecked that option but I still get the error messge.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •