FileLen Syntax Not working for Sharepoint Library url

Hello,
I have a template macro which loops through several text files each day and performs some modifications on each and then saves each as an .xlsx file. Occasionally these files are delivered blank or are just missing. I'm trying to screen out these 2 instances and successfully tested 1 option which looks at the size of the file in bytes using FileLen. My code works fine when I test on my local drive using my Temp Folder, but when I update to use a range which captures the sharepoint library url, it fails and gives a "Run time error 5; bad procedure call or argument." The url code itself (in column G) is not bad as I can run the full macro without the FileLen portion. Can anyone guide me as how to overcome this issue? If this is too little information I may be able to attach the full template here.

FileLen portion of the code is below; column G is the sharepoint library url range and column J is where the FileLen number is populated to.

Please Login or Register  to view this content.

Does the value in each row of column G contain both the path and file name?

Yes it does. Each row starts with "https" and ends in ".txt" Also I don't have any spaces in the names of the files stored in this library.

Checking if the file exists...

Please Login or Register  to view this content.

Thanks for the response Haluk, I took your code and updated with my particulars (just changed the source and output columns). The code cycled through fine with no errors, but it's outputting "0 bytes" for each file, and all except 1 should be showing data in them. Now these are text files (.txt). Will that make a difference?

I went ahead and tested on your Test file by just replacing the 3 hyperlinks with 3 of mine and still am getting the "0 bytes" on all of them.