9/24/2020 Excel Vba Adobe Pdf Printer
Creating a PDF from Excel typically requires printing to the “Adobe PDF” printer, selecting the location and file name to save the.pdf as, and finally getting. Excel General; VBA to print PDF's in A3 size. Of the Printer back to A4. First, Excel VBA has the ability to change paper sizes if the printer driver cooperates. Update hp printer driver for windows 8.
Active1 year, 11 months ago
![]()
Currently this is what I have.
Under Adobe PDF Settings, UNCHECK the box that says 'rely on system fonts only, do not use document fonts.' This is how I was able to solve it (at least at the time I needed it to work right). I had the same problem. Hit PDF print button. Click 'Properties' 3. Free pdf printer.
I understand how to ExportAsFixedFormat PDF but what I need to know how to do is to access the Create PDF function under Acrobat (As show in the picture below) using VBA. If I do ExportAsFixedFormat the links get flattened. Acrobat 'Create PDF' would allow me to convert an Excel to PDF with hyperlinks included.
How would I do that?
I am using Excel 2016 and Adobe Pro DC
These are my adobe references
Vba Excel Tutorial Pdf
Michael Downey
Michael DowneyMichael Downey
31533 gold badges1010 silver badges3434 bronze badges
4 Answers
Acrobat Reference should work
Here is the guide from Adobe Once added, you may use the following codeTip: It may lead you to correct coding -I'm not quite sure since I coded it 'blindly' because I don't have Acrobat in my PC-. Debug step by step to see what's doing.
Following pages may provide better assistance: Link1, Link2
SgdvaSgdva
2,11911 gold badge1010 silver badges2222 bronze badges
Anders Tornblad
13.9k77 gold badges4242 silver badges5959 bronze badges
David SyriacDavid Syriac
jellz77jellz77
Excel Vba Adobe Pdf Automation
You can publish any Excel Range as a PDF using ExportAsFixedFormat. There is no need to set a refernce to Acrobat.
user6432984
How To Add Adobe Pdf PrinterNot the answer you're looking for? Browse other questions tagged excelvbaexcel-vbapdfacrobat or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2020
Categories |