Print to foxit reader pdf printer how to#

Most VBA apps are probably internal apps (mine are), so I suppose you have a certain level of control about what software gets pre-installed on the machines that your app needs to work on. This depends on the kind of app youвЂ™re making. If you want to check this, you need to find a way that works in your Office/VBA version. I omitted that on purpose because as far as I know, there isnвЂ™t a single way to check this that works in newer and older Access versions alike (let alone other Office products like Excel). For example, it doesnвЂ™t check whether the passed printer really exists. Why SumatraPDF? Because it was the smallest and fastest PDF viewer that I could find.ДЄccording to the manual, SumatraPDF has the following command-line parameters for printing:

(this will probably work in other VBA flavors like Excel as well, but I tested it in MS Access only)

Print to foxit reader pdf printer how to#

In this post, IвЂ™ll show you how to use the free & open source SumatraPDF to print PDF files with VBA in MS Access. Plus, Adobe Reader is not the fastestвЂ¦on my machine, it takes several seconds until it has opened and sent the PDF to the printer.ДЇortunately, there are other PDF readers that do a better job. When you have existing PDF files that you need to send to a printer, the usual solution that you can find on the Internet is somehow calling Adobe Reader to print the fileвЂ¦but then Adobe Reader stays open and you need to close it again somehow.

This is about using VBA/MS Access to send existing PDF files to a printer, NOT about creating new PDF files from reports!