Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Excel 2007 file in 2003 creates very large file Jon Pearce Excel Discussion (Misc queries) 2 July 16th 09 07:20 PM
Can you save 1 sheet from a large file into another file? imktew Excel Worksheet Functions 2 January 17th 08 05:46 AM
very large file. Miri Excel Programming 2 March 19th 07 01:16 PM
File is too large [email protected] Excel Discussion (Misc queries) 1 June 15th 06 12:36 AM
Large File 56M Ramone[_2_] Excel Programming 1 July 1st 04 10:32 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"