How to use the FileLen Function (VBA)

This Excel tutorial explains how to use the Excel FileLen function with syntax and examples using VBA.

SUMMARY:

The Excel VBA FileLen function returns the size of a file in bytes.
The file size can be returned in kilobytes, megabytes and other similar size units.

PURPOSE:

To get the size of a file in bytes.

RETURN VALUE:

The FileLen function returns a numeric value in bytes.

REMARKS:

• If the specified file is not available then an error will occur.
• To obtain the length of an open file, use the LOF function.

FileLen Function VBA Code example:

Diffrent way to use the FileLen function using Excel VBA Code...

FileLen Function Example (as VBA code)

The FileLen function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the FileLen function used to get the size of an file in bytes.

Dim testResult As Long
testResult = FileLen("C:\myprofile.jpg")

In the above VBA code example, The testResult variable would now contain the size of the myprofile.jpg file.

VBA FileLen Function Error:

If you supply invalid path/name of the file to the FileLen function, you will get the error:
Run-time error '76': Path not found

---

---

Download Example Sample Excel File

FileLen-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…