📊 VBA (Excel)
Clean Up IIS log files (VBA)
Deletes every file in IIS log files after a confirmation prompt, using Scripting.FileSystemObject from Excel VBA. Locked files are skipped, not fatal.
IISLogsCleanup.bas
Attribute VB_Name = "IISLogsCleanup"
Option Explicit
Public Sub IISLogsCleanup()
Dim fso As Object
Dim folder As Object
Dim f As Object
Dim folderPath As String
Dim deletedCount As Long
Dim response As VbMsgBoxResult
folderPath = "C:\inetpub\logs\LogFiles"
Set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FolderExists(folderPath) Then
MsgBox "Folder not found:" & vbCrLf & folderPath, vbExclamation
Exit Sub
End If
response = MsgBox("Delete all files in:" & vbCrLf & folderPath & "?", vbYesNo + vbQuestion, "IIS log files")
If response <> vbYes Then Exit Sub
Set folder = fso.GetFolder(folderPath)
deletedCount = 0
For Each f In folder.Files
On Error Resume Next
f.Delete True
If Err.Number = 0 Then deletedCount = deletedCount + 1
Err.Clear
On Error GoTo 0
Next f
MsgBox deletedCount & " file(s) deleted from " & folderPath, vbInformation
End Sub