Hello my friends in this forum. Currently i am struggling with VB..

I managed to use VB to open up a text file in excel. but the text containing inside the file was not splited up. i wanted it to be split up.

i use this to split but in the end i split the filename of the textfile instead of the text inside the file. Can any kind soul willing to direct me to the correct path . Thanks and appriciated.



Dim i As Integer
Dim str_SplitArr() As String
str_SplitArr = filename.Split("1")

For i = 0 To UBound(str_SplitArr)
MsgBox(str_SplitArr(i))

Next i