Macro specifying file name when printing to PDF?
 

I have Excel 2002 and Acrobat Pro v.8 on my machine. My macro can print to
a PDF file, but a dialog box pops up asking for the filename. The macro
knows the folder and filename it wants to save as. How can I specifying
them in the macro so I don't have to manually enter them?

Don <www.donwiss.com (e-mail link at home page bottom).