Gustav Brock
gustav at cactus.dk
Mon Mar 1 02:50:41 CST 2004
Hi Vlad The quick-n-dirty road is to use Shell and this DOS command: copy file1.txt+file2.txt+file3.txt file.txt If you prefer VBA code and the files are relatively small, you can just open them one by one, read the lines and append them to the new file one by one. As posted many times here, Seth has on his site the basic code for reading and writing text files. /gustav > I have a small project that exports text files (3 of them) in a fixed > width format. Now the company requires that these 3 files be melded into > 1 text file only as apparently their import procedure knows when to > import the one file into separate tables at their end. > I have no problem creating the 3 separate text files, but how do you go > about melding these 3 separate files into 1? > Any ideas most welcome... > Regards > Vlad