Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I Am loping through a text file. I need to take two passes at the file. When
I exit the first loop I then proceed to the next loop where I want to start searching the file again from the first line. However the sData variable is still set to the line where the first loop exited the Do. How do I restart this? I tried using the "Open x For Input As #1" again in the second loop but I recieved an error message saying the file was already open. 'First Pass Open x For Input As #1 Do While EOF(1) Line Input #1, sData LineCount = LineCount + 1 If some condition = True Then Exit Do End if Loop LineCount = 0 'Second Pass Do While EOF(1) Line Input #1, sData LineCount = LineCount + 1 'Do something Loop Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
taking the file extension out of the file name | Excel Discussion (Misc queries) | |||
display text when mouse passes over a line | Excel Programming | |||
Excel File Taking Forever to Open | Excel Discussion (Misc queries) | |||
Taking formula to text | Excel Worksheet Functions | |||
taking one cell and adding text to it | Excel Programming |