Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Any Function

Status
Not open for further replies.

tide

Programmer
Feb 1, 2002
5
0
0
CN
There are any function to get the next line in a file?
 
if you a reading from a text file then the LINE INPUT statement reades one line at a time. The following code demonstrates:

Dim TextLine
Open "TESTFILE" For Input As #1 ' Open file.
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, TextLine ' Read line into variable.
Debug.Print TextLine ' Print to the Immediate window.
Loop
Close #1 ' Close file.

Hope this is what you are after.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top