Sub SizeOfFilesInFolder(f As String) As Long
Dim total As Long
For Each filename As String In File.ListFiles(f)
If File.IsDirectory(f, filename) = False Then
total = total + File.Size(f, filename)
Else
total = total + SizeOfFilesInFolder(f&"\"&filename)
End If
Next
Return total
End Sub