Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileLen with very large files
I need to determine the size of an input file to work out how many times to
run through a loop. One of my input files is 2,878,231,056 bytes long, and when I run FileLen it returns the value -1416736240 because FileLen returns a Long integer, and the range of Lond integers is only -2,147,483,648 to 2,147,483,647 Can anyone suggest how to determine file lengths for files which are bigger than 2,147,483,647 bytes? ( I might need to examine files which are bigger than 5 GB, so it will not always work to take the twos complement of the returned file size.) Grateful for any suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileLen with very large files
Look up filesystemobject in VBeditor Help
"simonc" wrote: I need to determine the size of an input file to work out how many times to run through a loop. One of my input files is 2,878,231,056 bytes long, and when I run FileLen it returns the value -1416736240 because FileLen returns a Long integer, and the range of Lond integers is only -2,147,483,648 to 2,147,483,647 Can anyone suggest how to determine file lengths for files which are bigger than 2,147,483,647 bytes? ( I might need to examine files which are bigger than 5 GB, so it will not always work to take the twos complement of the returned file size.) Grateful for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large excel files | Setting up and Configuration of Excel | |||
Very Large Files | Excel Discussion (Misc queries) | |||
Large files | Excel Discussion (Misc queries) | |||
Really large files, not sure why | Excel Worksheet Functions | |||
Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) |