@@SarnathR-m5u I think the problem is not with the size of the folder (I've got it working for folder size over 1 GB), it is rather with the fact that is one drive files.
Thank you for this but I don't think that this size is correct. For example my file is of 21GB and this shows 1120411194 bytes which converts to 1.1 GB. If you could share some insights? Thanks.
I understand you get that discrepancy regardless of using the FileSystemObject. I don't what's the reason, never seen that kind of miss-match. I wonder if you get the wrong size with FileLen too (first method explained). You could download Excel File Explorer and see what you get there: excelmacrobusiness.blogspot.com/2020/12/file-explorer.html
Hi, i cannot get size for a folder with a size more than 1GB. I am not even able to use msgbox command for this. Any idea why?
These are one drive files in my laptop
@@SarnathR-m5u I think the problem is not with the size of the folder (I've got it working for folder size over 1 GB), it is rather with the fact that is one drive files.
Thank you for this but I don't think that this size is correct. For example my file is of 21GB and this shows 1120411194 bytes which converts to 1.1 GB. If you could share some insights? Thanks.
I understand you get that discrepancy regardless of using the FileSystemObject. I don't what's the reason, never seen that kind of miss-match. I wonder if you get the wrong size with FileLen too (first method explained). You could download Excel File Explorer and see what you get there: excelmacrobusiness.blogspot.com/2020/12/file-explorer.html
Hello
Hello, is there something you want to ask, say, or share?