Delete files from the hard drive

August 15th, 2004 | Categories: Excel.mod | Tags:
-->

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
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. mahesh
    November 18th, 2004 at 03:34
    Reply | Quote | #1

    c:myfile.txt Doesn’t work

    c://myfile.txt Works

  2. Mark
    November 18th, 2004 at 08:23
    Reply | Quote | #2

    Thanks mahesh. Your correction works perfectly. I posted my original intention(which works also) in the corrected post for variety.