To read many text files and write it in the excel file

**nynamyna** · 12-11-2009, 06:44 PM

Hi everybody

I need help for reading data from text files and saving it under different columns in the excel file using vba macro.

For example: I have many text files in the following format

File 1:
1 2 3 4
1 3 5 7
1 3 1 8

File 2:
1 2 3 4
1 3 5 7
1 3 1 8

In excel file the above files should be saved one below the other seperated by the name of the text file, in seperate coumns as found in the text file.

I found an example online but it saves the data under a single column only. I tried changing it to my requirement, but I couldn't. I have attached the example that I found online.

Thanks
Bharath

**jrdnoland** · 12-11-2009, 07:50 PM

Have you tried to import the text file into excel?

Are the text files always delimited in the same way?

Can you post a sample of the text file you want to import, not the code you found somewhere?

**ravishankar** · 12-12-2009, 12:02 AM

HI
Try the macro in the attached file
Ravi

**nynamyna** · 12-12-2009, 02:52 AM

Hi Ravi

Thanks for the macro......I want the data to be imported slightly different....That is if I have four coulmns in the text file then when we import it should also be saved in different columns in the excel sheet........I have attached the sample of the format needed and the sample text file.....sorry I should have given it before......Sorry for not telling it clearly......

Thanks
Bharath

**ravishankar** · 12-12-2009, 06:19 AM

Hi
Save the file inside the folder with text files and run the macro.
Ravi

**nynamyna** · 12-12-2009, 01:09 PM

Hi Ravi

Thanks for the help....It is reading and writing the file in the same way I want.....Thank you very much....

Bharath

**nynamyna** · 12-12-2009, 11:59 PM

Hi Ravi

I need a small help.....I just need a small modification .......now the data is saved one below the other.....It would be easy for writing the count if it is saved one next to the other horizonatlly.......I tried doing it but I couldn't find the exact part of the code which does it.....I have attached the sample file
sorry I am giving a lot of trouble.......

Thanks
Bharath

**ravishankar** · 12-16-2009, 09:53 AM

Hi
The code is modified to collate text files horizontally.
Ravi

**nynamyna** · 12-16-2009, 12:54 PM

Hi Ravi

Thank you very much for the help......

Bharath

**JBeaucaire** · 12-16-2009, 01:51 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

To read many text files and write it in the excel file

LinkBack

Thread Tools

Rate This Thread

Display

To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Re: To read many text files and write it in the excel file

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions