Solved

Script to copy .csv data into an existing .xlsx worksheet.

Posted on 2009-04-08
2
282 Views
Last Modified: 2013-12-25
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


0
Comment
Question by:g8crapachino
[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
2 Comments
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 24128476
First off if the other pc's do not have excel then they will not be able to insert into the .xlsx file since it is MS proprietary.

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
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

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…

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.

Join & Ask a Question