Important many txt files into single sheet

[mroseto]

Hello,

I currently have 99 txt files that I would like to import in 1 single excel sheet. As you can imagine importing copying/pasting is brutally tedious so any help with this would be greatly appreciated. If it would help the cause at all, I can export the information as .xls.

Thanks in advance

Mike

 

[bertie]

Tips and Tricks -batch file to merge multiple .txt .csv files.

Open Notepad Start => All programs => Accessories => Notepad
type in: copy *.txt merged.txt
i.e., copy all text files into a file called merged.txt

click File => SaveAs
Name the file giving it a .bat extesion, i.e, "mergefiles.bat"
Set File type to All Files
Save the file to the same folder as the text files.

Navigate to the folder through MyComputer.
Double click on the batch file to run.

NB all text files in the folder will be merged intp the file called merged.txt

Now you only have one file to import into Excel.

 

[mroseto]

That is fantastic.

I never knew such a function existed. I can't thank you enough this has saved me hours of time.

Mike

 

[snb_]

translated in VBA:

Sub samen()
  Open "E:\samenvoeg_tekstbestanden.bat" For Output As #1
    Print #1, "copy *.txt samen.txt"
  Close
  Shell "E:\samenvoeg_tekstbestanden.bat"
End Sub

 

[James_B]

Thanks for sharing snb and Bertie. That's really neat.

 

[cwilloug]

This is fantastic!

Does anyone know if there's a way to ask the user for the folder in which all the data is placed?

Thanks as always,
Court