• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 995
  • Last Modified:

Excel to PDF converter (using VBA)

I would like to create a PDF from Excel VBA.
a)The PDF should have same colors as the charts in the original excel and
b) should also retain the hyper links in the original excel
1 Solution

VBA does not contain an Excel to PDF converter. You perhaps could invoke an Excel to PDF converter from a VBA routine but that's about all you can do. If VBA did contain such a facility there would be no need for stand-alone PDF applications such as 'EzeePDF' and many others around. You can get a free copy of 'EzeePDF' from:


Hope that helps

There are free PDF printing solutions out there using, e.g. Ghostscript.  Once you have created a pdf printer, you would simply issue the print command from within your VBA and point it to the pdf printer.  See http://pad.olsonnetwork.com/faqs/MakePDF_HOWTO_Images.html
I am using a redmon/ghoscript GPL 8.56 combination and confirm that hyperlinks are clickable in the resultant pdf and the resultant file is in colour (same as in the original excel sheet).  I did not need to use the PDFWriter application as I use the in-built pdfwriter device in ghostscript.  I also installed the adobe postscript drivers and used the distiller ppd file (available from adobe).
Forced accept.

EE Admin
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now