Print to PDF
 

I'm running '03 version of Excel and I need to know how to print a worksheet
to PDF via VBA code. I don't want the user to have to save the file, but the
code will save it in a predetermined location.

I've got an adobe printer installed that will work if I use File\Print and
print to the pdf writer.

Thanks in advance,
Chad