I need to save an active sheet as a pdf with a specified file name. I
have read various postings in this group and written a small macro to
send the active area of my sheet to pdf printer and all that works
fine. How do I specifiy what I want the resulting pdf file to be called
(by default it saves it as the same names as the the source file).
Please go easy on me, I am not a VB expert and not particularly
technical!