Function for FileLen

[Seth_]

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?

[alansidman]

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

Please Login or Register  to view this content.

[Seth_]

Alan, for the line that reads "sPath = InputBox("What is the full Path to Search?")" did you use a sharepoint url range?

[alansidman]

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.

[Seth_]

I'd vastly prefer to use local pc file directories as the code seems to work much better. Sharepoint is nothing but problematic in terms of how well automation code seems to work for me. Thanks for the suggestions though, I'll give it a try here.

[Seth_]

Yeah, this code is throwing an error, I think due to Sharepoint. The more research I do on this issue, the more I think employing this type of code with files stored on Sharepoint will be much more difficult.