ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Get with very large file (https://www.excelbanter.com/excel-programming/413235-using-get-very-large-file.html)

simonc

Using Get with very large file
 
I am trying to extract data from a 7GB binary file using Get. When the byte
number, which is calculated by the programme, exceeds the limit for a long
integer the programme crashes.

The documentation for Get says the recnumber parameter is of type
"Variant(Long)" but the behaviour above suggests it can't have a value
greater than a long integer. Is there a way of addressing points in the file
beyond this limit? Can you use filesystemobjects to do this?

I am using Excel 2000.

Grateful for assistance.


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com