I am making a macro in which users will request travel expenses with a userform in an excel workbook, this information will be filled in a worksheet, which is a format with ActiveX controls.
Since there are other sheets in the workbook, I decided to make the code open a new workbook only with the sheet containing the filled in format, and such form will be exported as a pdf file. Is the creation of the new workbook necessary? Or can I export this single sheet to pdf on the original workbook?
My second question is, how can I make the pdf save with today´s date? (which ever that date is)
Last but not least is that I would like this pdf to be e-mailed to me afterwards and I haven't had any success in what I'm trying.
I will post the code so far.
Thanks in advance