Hi Erin
Save As will save a copy of your initial workbook to a different name.
Your initial workbook's name remains.
So may be you could add some "Thisworkbook.Save" in your code (in case some
amendments have been made to the intitial workbook's data) before actually
saving it as with another name for your email attachment purposes.

Cordially
Pascal


"Erin" a écrit dans le message de
...
I have a VBA module which will email the open spreadsheet as an
attachment. I want to give the attachment a different name though.
Currently, I'm doing a 'Save As' under the new name and then emailing it.
This works okay for the email, but then I want the user put back under the
original workbook name. Is there a way to do this without doing another
saveas under the original file name?