Friends,
I have requirement somewhat complex.
I have a selection field with the team names as below.
Every week I will select Team A and the print the report as PDF and have to save in the name as Team A.pdf, this will be sent to management. Similarly for Team B,C and D.
Is it possible to create a Macro for a Button - If we click the button it has to select Team A and it has to print the report as PDF and it has to save automatically as Team A.pdf. So that I could have 4 buttons which will automatically print and save as PDF files in predefined names.
Appreciate your help.