did you try the split function. You can use something like
fields = Split(line_number, "~")
This will put the fields in the array fields, and then you can impor
only those numbers which you want by referring to them as field(0)
field(4), field(21), etc...

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584