importing multiple text files into one worksheet and one column

**hluk** · 05-16-2010, 12:58 AM

hi there,

i read this thread and i am trying to do a very similar thing:

http://www.excelforum.com/excel-prog...ml#post2307276

i have many text files that need to be combined into one text file. the easiest way i can imagine is to use excel to achieve this.

all the text files have only one column and what i want to do is import each text file, take the data and place it ALL into one column on the activesheet.

is there a simple modification that can be done to the code in the above thread to achieve this? or is it simplier to write another vba code?

any help would be appreciated!

thank you very much!

**JBeaucaire** · 05-16-2010, 01:02 AM

Microsoft has offered a couple of ready to try solutions for merging text files.

Check them out here.

**hluk** · 05-16-2010, 06:14 PM

thanks for the reply.

the methods provided work great, however i think they work well for copying one file to another?

i have over 30 files to combine, how should i adapt this code to load 30 text files and append them to one file?

thank you!

**JBeaucaire** · 05-16-2010, 08:56 PM

Something like this I suppose:

Please Login or Register  to view this content.

This will open every text file in the C:\2010 folder and add it to the file C:\2010\Imported\DEST.TXT.

**hluk** · 05-16-2010, 09:31 PM

sweet, it works!

the only thing is i have to use z_combined.txt as the destination file so that all the other files that starts with a 0-9 and a-y will open first.

because the program will run and if the file is already opened, it will give an error saying "error 55, file already opened"

small work around =)

thanks!