Extracting certain data from a text files to Excel using VBA

[puneetkansal04]

Hello rick i have some text files in a folder
i want to extract some data text from these files to excel

i want to extract some text after pppppppppp word and before aaaaaaaaaa word..

suppose in my text file pppppppppp 4547697864 aaaaaaaa is my text file and now i want to extract data between this
so i want extracted data as 4547697864 in first row
and for the 2nd file data extract in 2nd row

so can you please tell me can i extract data from all my text files to excel

i have tried mid function in excel that is functioning good but i want a vba script so can i directly import data from text files to excel file