Re Excel 2002

I am using the following to open an Outlook new mail window with the
attached workbook:-

objExcel.Dialogs(xlDialogSendMail).Show strInvoiceEmailAddress, "Latest
invoice attached"

I first saved the file so that the attachment would get a more
meaningful name.

I then want to delete the saved file with Kill... but the code does not
wait until the Outlook window is closed.

My query is this: is it possible to give the attachmnet a different
name to the default "Book1.xls", or how do I pause the code so that I
can delete the saved file and not get a message to say the file is in
use?

Many thanks.


--
thepython
------------------------------------------------------------------------
thepython's Profile: http://www.excelforum.com/member.php...o&userid=30563
View this thread: http://www.excelforum.com/showthread...hreadid=502126