Table of Content
TestFiles
First we check any file existing nor not before delete them, will generate a vbDirectory according to file pattern, then go through one by one until hit first file, return True.
Private Function TestFiles(FilePattern, pFolder)
TestFiles = False
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
Dim strFile As String
strFile = Dir(pFolder & FilePattern, vbDirectory)
'MsgBox strFile
'MsgBox pFolder & strFile
Do While strFile <> ""
If fso.FileExists(pFolder & strFile) Then
'MsgBox "Found file:" & pFolder & strFile
TestFiles = True
Exit Function
End If
strFile = Dir
Loop
Set fso = Nothing
End Function
script to delete number of files under one folder
Private Sub DeleteFiles(FilePattern, pFolder)
Set fso = CreateObject("Scripting.FileSystemObject")
'MsgBox pFolder & FilePattern
'Delete the files
If TestFiles(FilePattern, pFolder) Then
fso.DeleteFile pFolder & FilePattern, True
Else
'MsgBox pFolder & FilePattern & " not existing!"
End If
Set fso = Nothing
End Sub
test sample
This is test sample to delete all files under c:\test\
Private Sub delfilestest() DeleteFiles "*", "c:\test\" End Sub