Hi all.
I have an excel macro enabled file with multiple spreadsheets (Sheet 1, Sheet 2, Sheet 3).
I want to create a macro whereby I can save Sheet 3 as NEW pdf file named- Daily Report for 8 Jul 2016. The date will change everyday.
May I know how can I do it?
Bookmarks