Send via email macro enabled wrksheet (xlsm) as regular wrksheet (xlsx) using a macro code

Hello all,

I have a macro written out to send the active workbook to a specific email address.
However, I do not want my client to open the workbook and see all the macros that are there nor do I want him/her to run the macro but rather I want him/her to open the workbook in regular excel format (xlsx or xls), and, at the same time I want to keep the original macro enabled worksheet (xlsm)in my hard drive. So basically what I want to do is add a code to the email code that I already have and that it will copy the macro enabled workbook (xlsm) to the email in regular excel format (xlsx or xls).
(If I am not mistaken I think there is a code that can convert the xlsm workbook to an xls workbook, temporarily save it in the hard drive, send it via email and then kill the file right away.)
If anyone can help me out it would be greatly appreciated.

Please Login or Register  to view this content.

Hi kosherboy

Welcome to the Forum!!

Try this Code (modified from Ron DeBruin )

Please Login or Register  to view this content.

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You're welcome...glad I could help. Thanks for the Rep.