Delete files from the hard drive

---

Did you just dynamically create an *.xls file and now need to delete it from code? The following is a method to delete files on a hard drive from VBA. ***Caution: This actually works, so only use this code if you know 100% what you're doing.

1. Put the following code in a module

Sub DeleteMyFile()



On Error Resume Next

Kill "c:\myfile.txt"



End Sub