I have a spreadsheet that creates a PDF from a userform where I can select the worksheets I require.
I have a couple of issues:
1. For the life of me I can't work out how to change the location of the PDF before it saves it to the local users my documents. (Module5)
2. How to combine my email VBA (Module3) with to allow me create a PDF using Userform1 to then email it.
Ideally I would like to have the option to email or print.
See Attached file