Print to PDF from Excel using VBA

[etacti]

Good morning!

Our software company utilizes Excel and VBA to generate documents.

We currently are attempting setup some of our templates to call Primo or Nitro to print to PDF and attach in an email automatically.

We would like to know the following:

Is it possible to call Primo or Nitro to print an entire workbook or specific worksheet?
Does Primo or Nitro have the ability to select specific worksheets from within an Excel document and only print to PDF the selected sheets?

If so, how do we accomplish this?

THanks in advance for your assistance!:o

[OldManRiver]

E,

Code at the bottom of this link works for most:

http://www.ozgrid.com/forum/showthread.php?t=41743

OMR