I am trying to create a macro that will create pdf files. To do this manually, I go to the File-> Print menu, and in the select printers box, I change it from the default printer to the Adobe PDF file option. I need to build a macro that will automatically send/print the worksheet to a pdf file and ideally one that will also automatically provide a name for the pdf file when prompted. Can anyone help?