Function for FileLen

Good day,
Do anyone know if there is a function/formula which can be used to display the total size of a text file? I have a spreadsheet template on a Sharepoint library that checks 8 text files daily and modifies and saves content saved in each. I'd like to have this template screen out empty files so I can use a loop macro and I thought FileLen would be the best way to do that. But I can't get it to work like the function FileExists. Is it possible? Or does it only work through VBA code?

Here is a Macro I have used in the past that you can modify as necessary

Sub ListAllFile()

    Dim objFSO As Object
    Dim objFolder As Object
    Dim objFile As Object
    Dim ws As Worksheet
    Dim sPath As String
    Dim lrA As Long
    Dim lrB As Long

    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set ws = Worksheets.Add

    'Get the folder object associated with the directory
    sPath = InputBox("What is the full Path to Search?")
    Set objFolder = objFSO.GetFolder(sPath)
    ws.Cells(1, 1).Value = "The files found in " & objFolder.Name & " are:"
    ws.Cells(1, 2).Value = "The files found have modified dates:"
    ws.Cells(1, 3).Value = "The file Size is:"

    'Loop through the Files collection
    For Each objFile In objFolder.Files
    'If objFile.Name Like "*.pdf" Then
        lrA = Range("A" & Rows.Count).End(xlUp).Row
        lrB = Range("B" & Rows.Count).End(xlUp).Row
        ws.Range("A" & lrA + 1).Value = objFile.Name
        ws.Range("B" & lrB + 1).Value = objFile.DateLastModified
        ws.Range("C" & lrB + 1).Value = objFile.Size
    'End If
    Next
    'ws.Cells(2, 1).Delete
    'Clean up!
    Set objFolder = Nothing
    Set objFile = Nothing
    Set objFSO = Nothing

End Sub

I can't answer as I don't use Sharepoint. No longer employed and have no need. I use the Path associated with the sub folders I am searching. Suggest you try and see what happens.