merge excel files into csv
Posted on 2014-11-20
I have a bunch of xlsx files in a directory, I was able to get a vb utility that is able to convert them one at a time into a csv file.
I need help to find a way to loo[p through the directory and convert all files of a similar kind- say *.load.xlsx into load.csv
Any help will be appreciated, here's what the vbscript takes as its input
EXCEL_CVS.vbs load1.xlsx load1.csv
I am guessing once I have the individual files converted i could do a copy to merge the CSV files