File Size - VBA Function
Sub Get_File_Size()
File1 = "c:\temp\Sample.txt"
MsgBox "The Size of the File is " & FileLen(File1) & " bytes"
End Sub
Friday, May 04, 2007
Visual Basic for Applications (VBA) Forum (recent threads)
CodeKeep VBA Feed
Visual Studio Tools for Office Forum (recent threads)
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Office Business Applications (OBA) Team Blog
MSDN Code Gallery Published Resources For Tag VSTO
microsoft.public.vsnet.vstools.office Google Group
Posts
thank you
ReplyDeleteIs there any way to get the file size when a file is greater than 4GB ?
ReplyDeleteIf your file is over 4GB I'd suggest that VBA and Excel is the wrong medium...
ReplyDeleteBad suggestion..
ReplyDeleteThey didn't say that they had an Excel File bigger than 4GB, just how do I check to see if A (any) file is over 4GB..
smh
agreed, very bad suggestion.
ReplyDeleteIf FileLen(FilePathFileName) > 4000000000 Then
ReplyDelete4*1024*1024*1024:)
ReplyDelete