Deleting a File - Help ASAP

[poleary2000]

I am using the following code to send an e-mail. Basically, it copies the cells from a worksheet in the original workbook, opens a new workbook, pastes the information, saves the file and attaches to an Outlook message.

To attach the file, I had to first save the file to the harddrive. What I would like to do is delete the file after the ActiveWorkbook.Close? Can someone help ASAP

Cells.Copy

Set newBook = Workbooks.Add

Cells.PasteSpecial

With newBook
.SaveAs Filename:="blah blah blah"
End With

Dim olApp As Object, olMail As Object
Set olApp = CreateObject("Outlook.Application")
Set olMail = olApp.CreateItem(0)
olMail.To = strRecipients
olMail.Subject = "blah blah"
olMail.Body = "blah blah"
olMail.Attachments.Add ActiveWorkbook.FullName
olMail.Display

ActiveWorkbook.Close SaveChanges:=False

 

[Andrew Poulsom]

Help ASAP nearly put me off but try:

Kill "blah blah blah"

where "blah blah blah" is the Filename you used in your SaveAs statement.

 

[poleary2000]

Thanks for the prompt reply.

I try to never use ASAP or 911, however the last few posts I have made have received no response.

Thanks for your help. I'll try it out.

 

[poleary2000]

Thanks. That did it. I promise to limit my ASAP usage!!!!