Good morning GrishaP
You don't say what the ultimate object is re the processing of the data, but to bring in data from a text file you should be using the Input # function. The example below will dump the contents of a textfile into the active sheet, but there's no reason why it can't dump it into an array to process :
Sub GetText()
Open "d:\work\mytext.txt" For Input As #1
counter = 0
Do While Not EOF(1)
Line Input #1, textlines
Range("A1").Offset(counter, 0) = textlines
counter = counter + 1
Loop
Close #1
End Sub
HTH
DominicB
Bookmarks