Vba delete file

' Needs to add "Microsoft Scripting Runtime" reference to your file
Function FileExists(ByVal FileToTest As String) As Boolean
   FileExists = (Dir(FileToTest) <> "")
End Function

Sub DeleteFile(ByVal FileToDelete As String)
   If FileExists(FileToDelete) Then 'See above          
      ' First remove readonly attribute, if set
      SetAttr FileToDelete, vbNormal          
      ' Then delete the file
      Kill FileToDelete
   End If
End Sub

Source: stackoverflow.com

Similar codes

0 vote158 views1 answer
Excel vba select multiple shapes
VBA
0 vote169 views1 answer
Excel vba hide gridlines
VBA
0 vote150 views1 answer
Style percent not found vba
VBA
0 vote168 views2 answers
Vb.net include quotes in string
VBA
0 vote159 views1 answer
Vb window.minimize
VBA
0 vote155 views2 answers
Excel vba copy paste after last row
VBA
1 vote168 views1 answer
Excel vba unload userform
VBA
0 vote168 views1 answer
Not allow form to be resized
VBA
2 votes162 views1 answer
Excel vba check if key is in collection
VBA
3 votes200 views2 answers
Vba date to string
VBA