FileLen 函数 返回一个 Long,代表一个文件的长度,单位是字节 Option Explicit Dim strfFleNamePrivate Sub Command1_Click() Dim MySize CommonDialog1.ShowOpen strfFleName = CommonDialog1.FileName MySize = FileLen(strfFleName) Debug.Print MySize End Sub
Private Sub Command1_Click() Dim MySize CommonDialog1.ShowOpen strfFleName = CommonDialog1.FileName MySize = FileLen(strfFleName) MsgBox MySize / 1024 ^ 2 & "Mb" End Sub
获取 C:\1.TXT文本的大小MB 在加上判断,
Private Sub Command1_Click() Dim MySize MySize = FileLen("C:\1.TXT") If MySize > 5000000 Then MsgBox "文件太大" End If End Sub
返回一个 Long,代表一个文件的长度,单位是字节
Option Explicit
Dim strfFleNamePrivate Sub Command1_Click()
Dim MySize
CommonDialog1.ShowOpen
strfFleName = CommonDialog1.FileName
MySize = FileLen(strfFleName)
Debug.Print MySize
End Sub
Dim MySize
CommonDialog1.ShowOpen
strfFleName = CommonDialog1.FileName
MySize = FileLen(strfFleName)
MsgBox MySize / 1024 ^ 2 & "Mb"
End Sub
Dim MySize
MySize = FileLen("C:\1.TXT")
If MySize > 5000000 Then
MsgBox "文件太大"
End If
End Sub