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 vote200 views1 answer
Vba dropdown event
VBA
1 vote211 views1 answer
Vb.net get name by Selection Changed
VBA
-1 vote204 views1 answer
VBA check if a cell contains a letter or string
VBA
1 vote193 views2 answers
Get all column names from excel vba
VBA
0 vote229 views1 answer
Excel vba move down to next visible cell
VBA
8 votes512 views1 answer
Excel vba make word from bytes
VBA
0 vote220 views1 answer
Vba verticalalignment
VBA
1 vote192 views2 answers
Vba remove first 2 characters from string
VBA
3 votes209 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote194 views1 answer
Do until vb.net
VBA