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.
Bookmarks