Using VB to auto print documents to pdf files
 

'Lo,

I'm a novice VB user, and I'm trying to use VB to print (a
series of pages in a workbook)to Adobe pdf files.

Specifically, VB begins the print routine, then asks the
user to enter a file name. I would like to supress that
step and use a defined name for each sheet, so the user is
not required to enter a name and the pdfs are created
automatically.

Is this possible?

Cheers