An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Script to copy .csv data into an existing .xlsx worksheet.
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
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
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Easiest of all is therefore to put the VBA into the .xlsx file albeit as a .xlsm although it should be possible to do as a script as well.
Chris