Determining a file size: displays the size, in bytes, of the Excel executable file. It finds this value by using the FileLen function. : FileLen « File Path « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. File Path
3. FileLen

Determining a file size: displays the size, in bytes, of the Excel executable file. It finds this value by using the FileLen function.

 
Sub GetFileSize()
    Dim TheFile As String
    TheFile = "c:\MSOFFICE\EXCEL\EXCEL.EXE"
    MsgBox FileLen(TheFile)
End Sub

 

Related examples in the same category