Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() John, I've been doing a little more poking on your problem. I know your're doing VB but C++ has the abiliity manipulate file pointer in a way that VB can't. I've been playing with some C++ code that is really fast. I created a 500,000 record / 80 character file. The time to read the last 10 records is unmeasurable (it calculates to 0.00000000). The trick in this code is that you can't specify a number of records from the end. You have to specify a file offset from the end in bytes. However, it automatically syncs itself to the first full record following the offset point you select. Now, you can't use C++ directly but you could write a standard DLL wrapper around the function and include it in VB with a Declare Function. You could also create a COM wrapper around it. Would you like me to post it? Thanks, Jim Jim Vita Microsoft Developer Support This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to read all lines from a text file into cells C10:Cxxx ? | Excel Discussion (Misc queries) | |||
Copying certain lines from a text file | Excel Discussion (Misc queries) | |||
text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) | |||
Scripting.FileSystemObject | Excel Discussion (Misc queries) |