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

5 votes121 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote133 views1 answer
Vba run command
VBA
0 vote123 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote125 views1 answer
How to add line graph vb net
VBA
0 vote138 views1 answer
Vba character ascii code
VBA
5 votes134 views1 answer
Excel-vba get integer high byte
VBA
31 votes171 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote119 views1 answer
Vba change named range address
VBA
7 votes122 views1 answer
Excerl vba array to range
VBA
0 vote132 views1 answer
Excel vba paste all to each sheet in workbook
VBA