VBA code to save current worksheet as temporary PDF file and then add to my existing code

Okay, so here's what I have. I'm using the following code to send out a daily report workbook. But I need to also create a temporary PDF version of the current worksheet (the actual report worksheet), named identical to the Excel file but with PDF instead of xlsm of course, and attach that PDF file to my email along with my Excel file.

Here's what I'm using for just sending out the Excel file, with body text also referencing a PDF version.

Please Login or Register  to view this content.

Thank you.

Please Login or Register  to view this content.

Thank you, ranman, for such a quick reply. I'm not sure of the mechanics of this, being that I'm not very good with VBA, so could you please help me with the following:

How can I make this work with my Mail_Report and include the resulting PDF file with the Excel file in the email, if possible?

Thank you.

This macro would have to return the new file (pvFile ) so you can ATTACH it like you did the other file.
Or just put this code inside your macro just above the SEND command...
.Attachments.Add pvFile

Okay, sorry to be such a dolt, but I can't seem to make it work. Here's what I have, with the sub routine you posted first and then the one I already had below it (and with the line added that you mentioned above).

Please Login or Register  to view this content.

Note: always use OPTION EXPLICIT to help find typos!