extract specific data from a file

[darkhorse4321]

For this thread I would like to know once I opened a txt file instead of opening the entire contents from the file, I would like my macro to.

Step 1:
Look for the line that start with “subtest” and extract the word beside “subtest” and place it on column A.
Look at the image below.
6.JPG

Step 2:
Look for the line that starts with “connect”, and get the last word from the line that starts with “connect’ and place it in column B.
Look at the image below.
8.JPG

Step 3:
Do step 2 until the macro detect the line “end subtest”. Look at the image below.
7.JPG

Keep repeating the three steps until the end of the look at the image below
9.JPG

I have done step 1 and step 3 (look at my attached file). But I don’t know how to do step 2.

The image below shows how the final outcome looks like
http://www.iimmgg.com/image/be377ab1...faa940e850bac9

I have attached a sample file that I need to extract
I have attached a sample workbook
Sheet 1 shows how the final output should look like, and also contains a button with my initial codes
ana.zip

[snb]

Please Login or Register  to view this content.

[darkhorse4321]

Thanks snb for your help. it did extracted all the subtest except the last one. Once it goes to the last subtest the data extracted were not correct.
Take a look at the image below.
55.JPG

This is how it should actually look like
66.JPG

[snb]

So dive into the code and feel free to improve it.

[darkhorse4321]

that was very helpful
okay, i'll give it a try and see whether i can make it work.