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.

Programming Homework Help

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"