![]() ![]() 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) 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! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |