Hello,
Ultimately, I am trying to have my excel sheet saved as a PDF and then emailed. I have figured out a way to do that, however once I started tweaking it, I realized I am way out of my league.
I need to also be able to:
(1) save the file as the value in cell A40 of the current sheet...