Get certain words from a line into a cell

[mlarsen]

Hello

Just hoping someone can send me in the right direction here with a method that might work here. I am extracting data from text files based on finding a certain word. If found, the whole line in the text doc will be pasted into a row in excel. There are certain things in these rows like just the web address, or page title, that I want in the Excel doc rather than the entire line. Would this be parsing usign tokens or something? Any help or pointers would be great! Thanks a lot

Mark

 

[PHV]

Have a look here:

http://msdn2.microsoft.com/en-us/library/6wzad2b2.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886