Solved

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

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now