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 vote222 views1 answer
Excel named range sum
VBA
2 votes225 views1 answer
Excel vba check if key is in collection
VBA
0 vote220 views1 answer
Enter into cells data grid view
VBA
2 votes216 views2 answers
Vba code to remove duplicates from a column
VBA
4 votes225 views1 answer
Vba create directory
VBA
0 vote219 views1 answer
Vbnet check if number is even or odd
VBA
13 votes494 views2 answers
Vba write text file
VBA
0 vote217 views1 answer
Vbs send keys
VBA
0 vote211 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
31 votes515 views1 answer
Vba how to convert a column number into an Excel column
VBA