File size

[Janitor]

How can I determine the size of a file?

[ChrisJackson]

Hi Janitor.

Here's how to do it:

dim stFileSize as string

stFileSize = FileLen("c:\windows\desktop\yourfile.txt")

All the best.

Chris

[LG]

Hi, Janitor.


Dim MySize
MySize = FileLen("TESTFILE") ' Returns file length (bytes).

Larisa

[jkurpias]

Function FileLen(PathName As String) As Long Member of VBA.FileSystem
Returns the length of a file in bytes