So i am tring to read line by line from a text doc that i have saved my info to. Because each line is a different vairable i am tring to figure out, How do i use a loop to create a new variable for each line? Or is there a better way to achieve this?
Right now this is the basic code that i am useing to read line by line
Dim TextLine As String Do While objReader.Peek() <> -1 TextLine = TextLine & objReader.ReadLine() & vbNewLine Loop
Any and all help is appriciated, i did google and all that, i jsut cant find the part to write each line to a new variable.