Hey there,

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.

NVM i jsut used spilt and manualy assigned varibles to parts of the array that is formed useing split.