Hello
I have a folder full of cvs files from a macro that create ROI analysis. I would like to know if there are a macro that can read all the cvs in a folder and merge them into a one excel sheet.
I am aware of the plugin read and write excel but I do not know how can I adapt the macro of that plugin into my request.
I have been looking on the forum but I cannot find any macro that can do what I want.
Thanks in advance for any help.
Regards
There are commands that can open and read text files.CSV files are just text files, so you can open these files in succession. While opening you can create one big Results table and then you can save this results table to a new csv file that can be loaded in a spreadsheet.
You can even put functions in a text file that, as long as they are considered syntactically correct, can be read by your spreadsheet. This file contains digits 1 through 3, tab separated, and a formula:
1 2 3 =sum(a1:c1)
and after import in Excel or Numbers cell D1 will contain 6.
spreadsheet test.txt (17 Bytes)
This allows you to even generate column totals by entering the appropriate formulas in the last line.