June 13th, 2012, 08:43 PM
Hello Friends in this forum. I need help in VB
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)