Create PDF using VBA (Word, Excel, etc.). A little while ago I was able to develop excel script to print excel page as PDF file through intensive google search. Sub Print_PDF()'need to check Reference to Acrobat Distiller in Tools - -> References'Define the postscript and . Dim PSFile. Name As String. Dim PDFFile. Name As String. PSFile. Name = "c: \VBAPrint. PDF\Sample. ps"PDFFile. PDF to Word Converter. Convert your PDF files to Word documents for easy editing. Follow Us on Twitter. PDFZilla Screenshot. Learn How to Convert PDF to Word, Excel and Images etc. Learn How to Convert JPG to PDF Learn How to Merge PDF Files Learn How to Cut PDF Learn How to Rotate PDF. PDF Conversion. Name = "c: \VBAPrint. PDF\Sample. pdf" 'Print the Excel range to the postscript file. Active. Window. Selected. Sheets. Print. Out copies: =1, preview: =False, Active. Printer: ="Acrobat Distiller", _printtofile: =True, collate: =True, prtofilename: =PSFile. Name 'Convert the postscript file to . Dim my. PDF As Pdf. Distiller. Set my. PDF = New Pdf. Distillermy. PDF. File. To. PDF PSFile. Name, PDFFile. Name, ""End Sub But last week I found I couldn't print out color in PDF - only black and white. Then I used several days to search on google again but didn't find directly answers. With the help of all the different info I changed active. Printer from Acrobat Distiller to Adobe PDF. Then the problem was solved - I got colorful PDF file. Here is the new code - only a tiny change: Sub Print_PDF()'need to check Reference to Acrobat Distiller in Tools - -> References'Define the postscript and . Dim PSFile. Name As String. Dim PDFFile. Name As String. PSFile. Name = "c: \VBAPrint. PDF\Sample. ps"PDFFile. Name = "c: \VBAPrint. PDF\Sample. pdf" 'Print the Excel range to the postscript file. Active. Window. Selected. Sheets. Print. Out copies: =1, preview: =False, Active. Printer: ="Adobe PDF", _printtofile: =True, collate: =True, prtofilename: =PSFile. Name 'Convert the postscript file to . Dim my. PDF As Pdf. Distiller. Set my. PDF = New Pdf. Distillermy. PDF. File. To. PDF PSFile. Name, PDFFile. Name, ""End Sub. PDFZilla - PDF To Word, PDF To Excel, PDF To JPG, Merge PDF, Cut PDF, JPG To PDF All- in- One. Convert PDF To Word In 3 Clicks! Powerful PDF To Word Converter - PDFZilla. Editable - Edit Your PDF Documents In MS Word! Easily - Convert PDF To Word Document Just In Only 3 Clicks. High Quality - Convert PDF To Word with ALL text and Graphical Data. Page Selection - Convert Selected Pages of PDF File To Word document. Over 2. 0 Languages Supported - Besides English, PDFZilla Also supports German, French, Spanish, Italian and all Unicode Language PDF Files. Batch Mode - Convert 1,0. PDF Files in Bulk. Convert PDF To Word Now! Follow Us on Twitter. PDFZilla Screenshot. Learn How to Convert PDF to Word, Excel and Images etc. Learn How to Convert JPG to PDFLearn How to Merge PDF Files. Learn How to Cut PDFLearn How to Rotate PDFPDF Conversion Formats Supported. Output - PDF To: MS Word(*. DOC), MS Excel(*. XLS), Plain Text(*. Rich Text(*. RTF), JPEG(*. JPG), GIF(*. GIF), PNG(*. PNG), TIFF(*. TIF), Bitmap(*. BMP), Flash(*. SWF), Webpage(*. HTML). Create - Image To PDF: JPEG(*. JPG), GIF(*. GIF), PNG(*. PNG), TIFF(*. TIF), Bitmap(*. BMP), Photoshop(*. PSD), Icon(*. ico), PPM(*. PPM), TGA(*. tga). PDFZilla Key Features. Convert PDF to Word. Convert PDF to Word with all text and Graphical data. Convert PDF to Excel. Convert PDF to MS Excel format so that you can edit and extract PDF forms. Convert PDF to RTFConvert PDF to Rich Text Files. You can edit all text and graphic by Windows Wordpad. Convert PDF to TXTConvert PDF to plain text files. You can edit text by Notepad. Convert PDF to Images. Convert PDF to BMP, JPG, GIF or TIF files. Convert PDF to HTMLConvert PDF to HTML files and automatically generate the Index file. Convert PDF to SWFConvert PDF to Shockwave Flash Animation files which can be published on websites. Convert JPG to PDFCreate a PDF file from images like JPG/PNG/TIF/BMP/GIF etc. Rotate, Merge and Cut PDF Files. You can rotate PDF files 9. PDF files into one, or delete and cut pdf pages. Page Selection. Convert all the pages, or partial pages of PDF file. Easy to use software. Add a PDF File - > Select the Output File Format - > Click on Start Converting button, then just have a cup of coffee : ).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2016
Categories |