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
November 18th, 2004 at 3:34 am
c:myfile.txt Doesn’t work
c://myfile.txt Works
November 18th, 2004 at 8:23 am
Thanks mahesh. Your correction works perfectly. I posted my original intention(which works also) in the corrected post for variety.