I have hundreds of txt files (in fact, they are .csv files). When I import one txt file to excel, it opens me a Wizard and I can easily put the values separated by commas in the excel spreadsheet. If have have to open all files, It will take me several days so I'd like to do it using a batch or any other faster solution.
I'd like to know if there is a way to make this boring and time-consuming process automatically. I want to create a worksheet for each txt file in the same excel file. Any ideas?
If not possible in one sigle excel file, then at least in several excel files (one excel file for each txt) but automaticaly !
Thanks in advanced !