Outlook attachment
 

Erin, I suggest you try:

set wkb=workbooks("myworkbook")
strCopyName= "c:\folder1\folder2\file.xls"

'create the copy
wkb.savecopyas strCopyName
'emailcode here
'...


'delete the copy
kill strCopyName



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?RXJpbg==?=" wrote:

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?