Send Excel Workbook as PDF but not save

[Dotreena]

Hi guys,

I have a workbook with a code attached which allows me to email the workbook, renames the file to a cell selection within the workbook and then does not save the file.

This is the code

Please Login or Register  to view this content.

What I now need, is the code to work exactly the same but attach it to the email a pdf file and not an excel file.

Thanks

[MrMyagiii]

are you sure file is not being saved? since

Please Login or Register  to view this content.

seems to save your workbook as ".xlsm". you could try to change this to .pdf?

[Dotreena]

What it does is rename the file to that cell selection, but adds it on the end of the file name each time. That's another problem I have, but just needed to try and solve the pdf one first.

I have tried that with changing the file type to .pdf but when the user who has received the email tries to open the file it says it is corrupted and hasn't been decoded properly.