Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
5 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Script to copy .csv data into an existing .xlsx worksheet.
Posted on 2009-04-08
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If like me you are one who spends a lot of time working and scripting with cmd.exe, sometimes it is handy to be able to quickly view a calendar for a given month and year. This script will quickly do just that! Save the code posted below to a .bat …
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script. Many of these have come from the web or adaptations from snippets I find on the Web. Periodically I add to them when I come…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month5 days, 14 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.