Help needed in importing a text file to excel

[chandrup23]

Hi Friends,

I have a list of paths in my excel sheet for the text files(.txt). I have to write a code that takes the path and open a new workbook and copies that text file into the new workbook and save it.

Each text file should get copied into a separate sheets.
Can anyone help me with this .?

Thanks in advance.

[kalbasiatka]

Hi. It is necessary to see the text file and the result, save it in excel.

[chandrup23]

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.

[Norie]

Try recording a macro when you either open one of the text files via File>Open... or import it to a sheet using Data>From Text.

Either should generate code that can be adapted to work with your list of files.

[chandrup23]

Hi Norie,
Thanks for helping. I have got an idea to solve this.

Thanks alot.

[kalbasiatka]

Please Login or Register  to view this content.

[chandrup23]

Hi kalbasiatka,

Thanks for the reply. I tried this code this actally covert the text file into a excel file but i need to import all the text files into a new same workbook.

Can you help me Please?

[chandrup23]

Hi Norie,
I tried recording the macro as you suggested but while i am trying to run the macro by modifying the code i am getting an error "Run-time error 1004:"
"Excel cannot find the text file ".

This was the code when i recorded the macro i edited it according to my requirement .

Please Login or Register  to view this content.

Can you help me with this

[Norie]

This is how you would incorporate the variable file in the code.

Please Login or Register  to view this content.

[kalbasiatka]

Collect all text files in a book

Please Login or Register  to view this content.

[chandrup23]

Hi Norie,
Thanks alot it works fine.Thanks for helping me

[chandrup23]

Hi kalbasiatka,
Thanks alot for helping me.The code works fine.