I previously used the split string function many times on a text file dump.
Now it seems to not be able to split the line correctly.
It seems to be something in the text file dump but can't figure it out.
First Text File, line 1
1 $37.35 $24.26 9.25/
Second Text File, line 1
1 $22.35 $14.53 3.94/
I even put the first text file line into the second text file line and it works but the original does not
My code is simply reading in each line of a file then splitting it into an array.
Line Input #FileNum, DataLine
MyInfo = Split(DataLine, " ")
ActiveWorkbook.Worksheets("TestArea").Cells(j + 4, 8) = Trim(MyInfo(0))
ActiveWorkbook.Worksheets("TestArea").Cells(j + 4, 9) = Trim(MyInfo(1))
Results using First text file is Myinfo(0) = " 1" MyInfo (1) = " $37.35" and so on
Results using Second text file is Myinfo(0) = " 1 $22.35 $14.53 3.94/" and MyInfo(1) is out of range
I have also tried MyInfo = Split(DataLine) as I know the space is default delimiter.
I am truly baffled as to cause.
FIrst time poster, hope I did this right!