locked
Print to PDF RRS feed

  • Question

  • I want to be able to print the output of an Excel file to a PDF file.  I have an installed PDF printer driver and I have also found in VBA the Acrobat Type Library.  Using either of these how in VBA do I print to a PDF file?

    I have been looking around and have found -

    PDDoc.Save 33, outputfilename.pdf which is supposed to be using the type library

    and

    Application.ActivePrinter = "doPDF v6 on DOP6:"
        ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
            "doPDF v6 on DOP6:"

    (Free PDF printer driver). This works upto the point of asking for the output file name.

    Thanks Dean

    Tuesday, September 21, 2010 1:34 PM

Answers

All replies