Public Function getFileSize(sFileName As String, Optional sUnit As String = "") As Double
Dim fso As Object
Dim f As Object
If Dir(sFileName) = "" Then
getFileSize = 0
Exit Function
End If
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(sFileName)
If sUnit = "b" Or sUnit = "B" Then
getFileSize = f.Size
ElseIf sUnit = "M" Or sUnit = "m" Then
getFileSize = f.Size / 1024 / 1024
ElseIf sUnit = "G" Or sUnit = "g" Then
getFileSize = f.Size / 1024 / 1024 / 1024
Else
getFileSize = f.Size / 1024
End If
End Function
Public Function getPicHeight(sFileName As String) As Long
Dim p As Object
On Error GoTo Err_Trap
Set p = LoadPicture(sFileName)
getPicHeight = CLng(p.Height * 24 / 635)
Exit Function
Err_Trap:
getPicHeight = -1
End Function
Public Function getPicWidth(sFileName As String) As Long
Dim p As Object
On Error GoTo Err_Trap
Set p = LoadPicture(sFileName)
getPicWidth = CLng(p.Width * 24 / 635)
Exit Function
Err_Trap:
getPicWidth = -1
End Function