Printing Sheet to PDF via Macro Code

[Simon]

Hi,

I have an excel worksheet that I would like to be able to print to pdf
through some macro code. The PDF printing application that I'm using is PDF
reDirect v2, does anyone have any ideas as to how I can go about printing the
sheet with Macro Code?

Thanks.

 

[Roland]

Here is how you call the prineter you want to use

Application.Activeprinter = "NAME OF PRINTER"

 

[Simon]

Thanks. Is it possible to save the file as a .pdf through macro code? If
so, how would you do that?

 

[Roland]

Simon

The easiest way to teach yourself is to go into the spreadsheet record a
macro while doing the procedure you want then read the code and take out the
pieces that are applicable.