View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jacques Brun Jacques Brun is offline
external usenet poster
 
Posts: 7
Default Excel 2000 Hanging while reading large file with Line Input

My input was unclear. To clarify
"Fini" is a boolean depending on EOF(1) and other conditions
When I use a breakpoint and step by step execution Excel hangs
when going to the "Line input #1, Inbuf" . The first execution
of this line of code is never ending. With the same input fil
truncated to 10 MB the program works as intended ... So
suspect that the cause is the size of the input file (232 MB)
and some Excel setup somewhere

Jacques Bru

----- Tom Ogilvy wrote: ----

Open InvFile For Input As #1 ' Open Input fil

Do While Not Eof(1
Line Input #1, Inbu
Loo

is the usual way to write this

--
Regards
Tom Ogilv



"Jacques Brun" wrote in messag
..
Sorry something went wrong with my initial input. It should have been ..
I'm using a VB Code that reads large files to produce statistics. It Work

wit
Excel under NT 4 With an input file of 232 MB. With Excel 2000 under XP i

remain
stuck on the first Line input instruction. However with the same inpu

file truncate
to 10 MB it works perfectly. I suspect some setup problem (buffer siz

somewhere
the code is as follows
Open InvFile For Input As #1 ' Open Input fil
Do While Not Fin

Line Input #1, Inbu
...........
Any help would be highly appreciate

Regard
Jacques Bru