I'm doing some tests on 5 machines where the test results are output to 5 separate .csv files copied to a share. I then manually open each .csv in excel then copy-n-paste them into my main .xlsx . The .xlsx has specific worksheets for each of the 5 machines and have various excel formulas to sum up and tabulate the results.
What I would like is a script to automate the copy of data from the individual .csv files to their corresponding worksheets in the main .xlsx. I'd prefer VB script or something that can be run on machines which may or may not have Excel installed. Any ideas? Thanks