How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

Question

I'm attempting to print a sheet's used area, but I want to store it as an a.pdf file, thus I want to use the Nitro PDF Creator tool. I've already tried using activesheet.usedrange.print, however, I am unsure of how to indicate that I want to use Nitro PDF.

Can someone please help me with this?

Answer 1

you can use the built-in excel facilities to create a PDF? In case you didn't know, you can use something like -  ActiveSheet.ExportAsFixedFormat to create PDFs without using external applications.