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 vote283 views1 answer
Convert number to minutes in vba
VBA
0 vote292 views1 answer
Excel vba ternary
VBA
1 vote285 views1 answer
Change the first item in a queue vb.net
VBA
0 vote276 views1 answer
Change whcih control a user has selected vb
VBA
0 vote311 views1 answer
Excel delete ever other vba
VBA
4 votes300 views2 answers
Vba last row
VBA
0 vote272 views1 answer
Remove first character from string vb
VBA
0 vote291 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
2 votes280 views1 answer
Vba round number
VBA
0 vote336 views1 answer
How to call gcd in vba
VBA