谢谢!我用了解下面的函数, 但有时会出现溢出错误,不知道是怎么回事? Function filesize(strFile As String) As Integer Dim fso ,f Set fso = CreateObject("Scripting.FileSystemObject") Set f = Fso.GetFile(strFile) filesize = f.Size'在这里出错 Set Fso = Nothing Set f = Nothing
End Function
如果文件不存在会出异常 Function filesize(ByVal strFile As String) As Integer Dim fso, f fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists(strFile) Then '先判断文件是否存在先 f = fso.GetFile(strFile) filesize = f.Size '在这里出错 Else filesize = -1 End If fso = Nothing f = Nothing End Function
Function filesize(ByVal strFile As String) As Integer 估计是这句错了 integer最大值是64K 相信一般的文件都大于这个数字吧 改成long 试试 Function filesize(ByVal strFile As String) As Long
msgbox FileLen(App.Path & "\book2006.mdb")
其中book2006.mdb改给您要查询文件的名称即可
但有时会出现溢出错误,不知道是怎么回事?
Function filesize(strFile As String) As Integer
Dim fso ,f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = Fso.GetFile(strFile)
filesize = f.Size'在这里出错
Set Fso = Nothing
Set f = Nothing
End Function
Dim fso, f
fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(strFile) Then '先判断文件是否存在先
f = fso.GetFile(strFile)
filesize = f.Size '在这里出错
Else
filesize = -1
End If fso = Nothing
f = Nothing
End Function
估计是这句错了 integer最大值是64K 相信一般的文件都大于这个数字吧
改成long 试试
Function filesize(ByVal strFile As String) As Long
我发现文件大了就出错,但改成LONG也不行,不知道为什么?
谢谢各位,能不能再帮忙给看看?