Just as a point of interest I tend to use the FileSystem object to delete a file in VBA rather than just the KILL command. I am just wondering which is the better way of doing this, I presume the FileSystem approach does take a little more resources to run as you need to create the object but besides that I was just interested in other peoples views on this.
Dim filesys As FileSystemObject
Set filesys = CreateObject("Scripting.FileSystemObject")
filesys.DeleteFile "c:\temp.test.txt", True