Excel 2007 Save as PDF Macro help
 

Can anyone offer help for the following Macro I am needing in Excel 2007. The function would be as follows. Need help with turning this into code. Thanks so much in advance!! 1) Open file name: Y:/P21.xls 2) Open file name: Y:/PriceSheet.xlt (Note: Pricesheet.xlt pulls date from P21.xls) 3)...