vba to Return Value from text line against value in other text line

[joogibabu]

Hi

I have large number of text files from which i have to prepare an excel sheet having following detail
1)Date
2) time
3) MWh

Data in text file is logged as follows.

Dates and time is sorted in format (yymmddhhmm) against each 0.1.2*(n)
MWh are shown as 0000000.0 against each 1.8.0*(n)

( n starting from 01 to 15 )


How do i write this data in Excel with vba as follows

Date Time Mwh
Date against 0.1.2*01 Time against 0.1.2*01 Mwh against 1.8.0*01
Date against 0.1.2*02 Time against 0.1.2*02 Mwh against 1.8.0*02
Date against 0.1.2*03 Time against 0.1.2*03 Mwh against 1.8.0*03
.
.
.
.
.
Date against 0.1.2*15 Time against 0.1.2*15 Mwh against 1.8.0*15

Text file is attached. 41512040 .txt

[watersev]

hi joogibabu, option, please check attachment, press Run button or run code "test" and select folder with .txt files to process

[joogibabu]

Many thanks

it works

Regards