View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefan Hoyos Stefan Hoyos is offline
external usenet poster
 
Posts: 1
Default File length of large files

Hello,

I have a problem retrieving file length of large files greater then 2 GB
using function FileLen(strFileName). This function returns long values with 4
Byte, delivering negative values for file size above 2 GB and recycles above
4 GB.
Is there another way to retrieve the filesize in excel working for large
files.
I have a list of filenames in Excel and need to do some calculations and
reporting on the filesize.
Any help appreciated. Thanks.

Stefan Hoyos