Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 4th, 2012, 11:06 AM
Registered User
 
Join Date: Nov 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default extra information from several excel files

Hello all,
I have a folder with 22 000 excel files. All the excel files have the same layout ie they have the same kind of information in the same cell addresses. I will like to extract the contents of cells A1, I20 and J20 from each excel file and append it on the next row in a new excel file. I think this can be automated with vbscript but do not master the language and its objects. The algorithm below is exactly what I will like my script to do. Can someone write it for me in vbscript? thanks in advance

ALGORITHM
' Folder contains the path to the directory containing my excel files
variable Folder = "c:\MyExcelFiles"
' List is the new excel file I want to produce
variable List = "c:\List.xls"
For each File in Folder
- open the file with excel application
- hide the excel application window (ie visible = false)
- open worksheet number 1
- copy contents of cells A1, I20 and J20
- append the data to the file List.xls
Loop

End Algorithm
Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel makes extra files rtr1900 Excel VBA 3 April 29th, 2009 06:15 AM
Extra redundant row after export to excel yukijocelyn ASP.NET 2.0 Basics 0 October 2nd, 2007 08:00 PM
Extra Information in displayed URL wlangel ASP.NET 2.0 Basics 0 March 6th, 2007 10:34 AM
Using VBA in excel to move information am6019a VB How-To 2 June 14th, 2006 08:15 AM
How to write files information to mysql db using p method PHP Databases 4 February 14th, 2006 09:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.