Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    41

    Unanswered: Export from Excel to .pdf format?

    Good day,

    I am wondering is it possible to export an excel document to .pdf format in the Excel 2003 program, similar to the feature available in OpenOffice.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can buy third party tools that will make this simple, such as ScanSoft, or you can use free utilities such as GhostScript that make it almost as easy, but I don't know of a native Excel tool that will make PDF files.

    -PatP
    Last edited by Pat Phelan; 01-26-06 at 18:24.

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Unless, of course, you use XL 2004 on Mac OS X.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by justlearning200
    Good day,

    I am wondering is it possible to export an excel document to .pdf format in the Excel 2003 program, similar to the feature available in OpenOffice.

    Thanks
    CutePDF.

    You can't, that I know, do it programatically unless you send key events to the print dialog. (Which is klugey.)

    You also can't get nifty PDF features like hyperlinks or bookmarks.

  5. #5
    Join Date
    Jul 2011
    Posts
    3

    Smile Re: Excel to PDF

    Hey guys! I see you have a problem converting excel to pdf. I ran into that awhile ago, and I found a similar program to be quite useful, especially in business. At my work we use this program that quickly and painlessly converts my excel documents into pdf, taking away agonizing hours of manually entering all the information (such as statistics, invoices, etc.). It provides my business a simple way to make individualized statements for our business associates. Check it out here: Excel to PDF

  6. #6
    Join Date
    Sep 2011
    Posts
    1

    Excel to pdf

    You can use the word, excel and powerpoint to pdf conversion tool that is available online.

    Pdf Tools Online - Watermark and Pdf Conversion


    Quote Originally Posted by justlearning200 View Post
    Good day,

    I am wondering is it possible to export an excel document to .pdf format in the Excel 2003 program, similar to the feature available in OpenOffice.

    Thanks

  7. #7
    Join Date
    Dec 2011
    Posts
    1

    Simple

    Modify this to serve your needs. Be sure to Thank Ken.




    Option Explicit
    Sub PrintToPDF_Late()
    'Author : Ken Puls (Excelguru Help Site - Welcome)
    'Macro Purpose: Print to PDF file using PDFCreator
    ' (Download from PDFCreator | Free Business & Enterprise software downloads at SourceForge.net)
    ' Designed for late bind, no references req'd

    Dim pdfjob As Object
    Dim sPDFName As String
    Dim sPDFPath As String

    '/// Change the output file name here! ///
    sPDFName = "testPDF.pdf"
    sPDFPath = ActiveWorkbook.Path & Application.PathSeparator

    'Check if worksheet is empty and exit if so
    If IsEmpty(ActiveSheet.UsedRange) Then Exit Sub

    Set pdfjob = CreateObject("PDFCreator.clsPDFCreator")

    With pdfjob
    If .cStart("/NoProcessingAtStartup") = False Then
    MsgBox "Can't initialize PDFCreator.", vbCritical + _
    vbOKOnly, "PrtPDFCreator"
    Exit Sub
    End If
    .cOption("UseAutosave") = 1
    .cOption("UseAutosaveDirectory") = 1
    .cOption("AutosaveDirectory") = sPDFPath
    .cOption("AutosaveFilename") = sPDFName
    .cOption("AutosaveFormat") = 0 ' 0 = PDF
    .cClearCache
    End With

    'Print the document to PDF
    ActiveSheet.PrintOut copies:=1, ActivePrinter:="PDFCreator"

    'Wait until the print job has entered the print queue
    Do Until pdfjob.cCountOfPrintjobs = 1
    DoEvents
    Loop
    pdfjob.cPrinterStop = False

    'Wait until PDF creator is finished then release the objects
    Do Until pdfjob.cCountOfPrintjobs = 0
    DoEvents
    Loop
    pdfjob.cClose
    Set pdfjob = Nothing
    End Sub
    Print Multiple Worksheets to Multiple PDF Files:

  8. #8
    Join Date
    Jul 2013
    Posts
    3
    You can use online tools like Aspose.Cells to export your excel file to .pdf format and it also allows users to use language they want to use to export their documents like .NET and Java etc.

Posting Permissions

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