📊 VBA (Excel)
Report Size of Google Chrome's browser cache (VBA)
Reports the total size and top-level file count of Google Chrome's browser cache using Scripting.FileSystemObject, straight from Excel VBA.
ChromeCacheSizeReport.bas
Attribute VB_Name = "ChromeCacheSizeReport"
Option Explicit
Public Sub ChromeCacheSizeReport()
Dim fso As Object
Dim folder As Object
Dim folderPath As String
folderPath = Environ("LOCALAPPDATA") & "\Google\Chrome\User Data\Default\Cache"
Set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FolderExists(folderPath) Then
MsgBox "Folder not found:" & vbCrLf & folderPath, vbExclamation
Exit Sub
End If
Set folder = fso.GetFolder(folderPath)
MsgBox "Google Chrome's browser cache" & vbCrLf & folderPath & vbCrLf & _
"Size: " & Format(folder.Size / 1048576, "#,##0.00") & " MB" & vbCrLf & _
"Files (top level): " & folder.Files.Count, vbInformation
End Sub