Programming Homework Help
Programming Homework Help. Excel Personal workbook macro to save as pdf in current directory
Excel Personal workbook macro to save as pdf in current directory
I want to record macro in personal workbook for the following.
1. Activate Book1.xlsx
2. Select sheets Sheet3, Sheet4 and Sheet6
3. Save these selected sheets as .pdf in the same directory where Book1.xls is saved
4. Name of the saved .pdf file should be the name what is written in Range A1 of Sheet1 of Book1.xlsx and suffix “20” after the name
Please provide the macro code for the same.
Thank you.