Help - Need to Convert Excel TO PDF FAST - No Printing

Discussion in 'OT Technology' started by Coottie, Jun 6, 2008.

  1. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    First off, any solution suggesting that we have to open up the excel file and print to a PDF file is NOT an acceptable solution.

    I'm looking for a way to convert excel files to PDF without having to open up excel at all. Anyone know of a program.

    The time it takes to open an excel file and print to PDF, while easy for you and me, takes too much time for my customers because of the volume that they are doing. So we need a fast way to do this.

    Anyone....anyone?? Bueller???
     
  2. critter783

    critter783 OT Supporter

    Joined:
    Jul 15, 2005
    Messages:
    1,785
    Likes Received:
    0
    script the print action.
     
  3. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Was hoping for an off the shelf app. I have a hard time believing there isn't some app out there that does this already.
     
  4. Chris

    Chris New Member

    Joined:
    Oct 27, 2003
    Messages:
    14,711
    Likes Received:
    0
    Location:
    Texas on my mind
    adobe pro 8

    [​IMG]
     
  5. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Cool....did you try it?
    How does it handle multiple worksheets within 1 workbook?
    Also...is that Acrobat 8 pro?
     
  6. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
     
  7. Chris

    Chris New Member

    Joined:
    Oct 27, 2003
    Messages:
    14,711
    Likes Received:
    0
    Location:
    Texas on my mind
  8. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,658
    Likes Received:
    0
    Location:
    Austin
    what version of Office are you running?

    2007 Microsoft Office Add-in: Microsoft Save as PDF
    http://www.microsoft.com/downloads/...3C-6D89-4F15-991B-63B07BA5F2E5&displaylang=en


    if you use adobe, you can set your default printer to acrobat distiller (dont recall the exact name)
    then use some code like this:

    http://www.access-programmers.co.uk/forums/archive/index.php/t-105325.html

    you will just need to make the code wait for each print job.

    there is plenty of code floating around google on how to do this. if you are still stuck tomorrow PM me and i will help you out.
     
    Last edited: Jun 6, 2008
  9. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
  10. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    We'll be converting them to 2007 eventually. Unfortunately, they don't want to wait.
    Thanks, I'll look this stuff over.
     
  11. Chris

    Chris New Member

    Joined:
    Oct 27, 2003
    Messages:
    14,711
    Likes Received:
    0
    Location:
    Texas on my mind
    replied
     
  12. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Thanks but it only pulled the information from sheet 3, there was data on all 3 of the sheets. Was there any indication that you could choose the sheet to convert? I saved the spreadsheet with the focus on the 3rd sheet.
     
  13. Chris

    Chris New Member

    Joined:
    Oct 27, 2003
    Messages:
    14,711
    Likes Received:
    0
    Location:
    Texas on my mind
    Wirelessly posted via wap.offtopic.com (Blackberry 8300: Opera/9.50 (J2ME/MIDP; Opera Mini/4.1.11355/514; U; en))

    Not sure, I will play with it later
     
  14. DarqueGT

    DarqueGT New Member

    Joined:
    Nov 29, 2004
    Messages:
    211
    Likes Received:
    0
    dunno if excel will do it or not but you could try PrimoPDF. That's what I use.
     
  15. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    I have Adobe Pro and print to pdf all the time. Works great.

    It will create a pdf that looks exactly like anything being printed. To print all 3 sheets you need to change your print options in Excel to print all sheets in the workbook.
     
  16. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    did you even bother reading either the title or the original post?

    I said....NO PRINTING

    That's the whole problem. Printing to PDF while easy is too slow.
     
  17. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    I did, and printing to PDF is not printing as I thought you meant. Normally when someone states no printing they mean they don't want to physically print and then scan to pdf. So, since your feel like being an ass I guess I won't continue with my next suggestion (you can batch convert with Adobe Pro as well while choosing to convert all sheets or just sheet 1, but figure that out on your own).

    And in all honesty, having Excel open and loading each sheet and printing to pdf individually normally is faster than strait batch converting anyway from my experience (using Adobe software).
     
  18. EkriirkE

    EkriirkE Zika Xenu OT Supporter

    Joined:
    Jan 11, 2004
    Messages:
    14,799
    Likes Received:
    0
    Location:
    Dublin & San Francisco, CA
    PDFCreator has a utility to independently convert files to PDF... as well as being a PDF printer
     
  19. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Great little program but I thought the batch scripting it allowed was still "print" orientated.
     
  20. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    You didn't read the whole first post then because I clearly said: "The time it takes to open an excel file and print to PDF, while easy for you and me, takes too much time for my customers because of the volume that they are doing. So we need a fast way to do this."
    :rofl:
    I hurt your feelings because you didn't read?? :rofl::rofl:

    Oh man...that's rich.

    But since you're so sensitive, thanks for trying to help even if your post took more time, was not an acceptable solution and generally has to be ignored for not providing an acceptable solution.

    I guess I will figure it out on my own because Chris already suggested and tested Adobe 8.
    Opening a printing to PDF is unacceptable because it's too slow, so batch converting is probably not going to help either.

    Thanks for uhm......well.....trying?
     
  21. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Thanks...I'll look into it.
     
  22. DatacomGuy

    DatacomGuy is moving to Canada

    Joined:
    Oct 14, 2002
    Messages:
    16,546
    Likes Received:
    0
    Location:
    Tampa, FL
    +1 for Adobe 8 Pro
     

Share This Page