Using Excel 2010
I have an application that creates several .csv files in the same folder.
I would like to combine all the .csv files into one master spreadsheet.
I used copy d:\inventory\*.csv n:\inventory\master.csv
That works but it is not what I want.
That places all the .csv files into one sheet.
I would like to create and individual sheet for each file
the would create a spreadsheet
sheet1 sheet2 sheet3
Thanks in advance for your help