1. load the file into a string like this,2. split the string using Split() function, delimiter is vbCrLf, it wil become an arrayCode:SomeString = Input(LOF(1), #1)
3. once u get the array, loop thru array Lbound to Ubound to find VAI using InStr() function, once u get the line number of VAI, u can get the 27th(from VAI) string in array.





Reply With Quote