Parsing

[Roy]

Hello,

I have an Excel application where I read a text file.Recently the text
file had a change and had three(3) new fields added.This data is now
in the last column.I want to parse this data which has a space
delimiter into three seperate columns.There are 10 fields and the data
is captured in the last column.How do I do this in VBA without the
"text to column" manual method.

Thanks,
Roy

 

[JE McGimpsey]

Try using the VBA TextToColumns method...