Help needed in importing a text file to excel

Hi kalbasiatka,

Thanks for the reply . I have attached my a sample textfile .
There will be similar files in the folder whose path will be present in the excel sheet.
I need to import the complete data from the text files by opening a new excel and save it.
One text file per sheet then i need to add next sheet to copy the next text file using vba.

Can you please help me.