copy specific values from text file to another excel sheet using vba

[alex gomes]

Hello,

I am trying to extract certain data from a text

file(C:\Users\mondals\Desktop\Source.txt) into an Excel spreadsheet. I'm using MS Office 2010 . I saved my files as TEXT formatted files and now I need to pull information from the text files.Here is a list of the information I need to extract from the text file:
Lines starting with

103 0 TestTime
203 0 TestTime
303 0 TestTime
403 0 TestTime
503 0 TestTime
603 0 TestTime
703 0 TestTime
803 0 TestTime

Example: Example: 103 0 TestTime -1 0.0000 mSec 60.3948 mSec 4000.0000 mSec 0.0000 m 0
from this lines I want to copy 60.3948 and so on.

Note: Please go through the attached doc Result.xlsx

And ....

from following line i want copy the values
104 0 TimeStdDev
204 0 TimeStdDev
304 0 TimeStdDev
404 0 TimeStdDev
504 0 TimeStdDev
604 0 TimeStdDev
704 0 TimeStdDev
804 0 TimeStdDev


Example: 104 0 TimeStdDev -1 0.0000 mSec 2.6139 mSec 10000.0000 mSec 0.0000 m 0
from this line i have to copy 2.6139.

Attached sample txt file and required output excel file

txt file=Source.txt
Xlsx file= Result.xlsx

Note: Please go through the attached doc

Really appreciate your help!!!!

 

[Deepak]

I failed to understand why u have started new thread irrespective to clear explanation at below!

http://chandoo.org/forum/threads/copy-specific-from-a-text-file-to-excel-sheet-using-vba.28903/

I am locking down this due to duplication.