Solved

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

Posted on 2009-04-08
2
278 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
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

777 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