Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 8th 04, 01:11 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2004
Posts: 3
Default Create a batch file from a number of Excel File

I have a folder (on a network drive) which contains a number Excel
file which are all created from one single Excel template file. There
is a hidden Worksheet named "DATA" in each of these excel files.

I wanted to write code that would do the following:
1) From all the Excel files on the network drive select only those
that were modified today
2) From the selected Excel files, copy the values from Range (A1:A75)
on the "Data" worksheet of each selected file & paste these values to
a new file in column A (from A1:A75). Next, go to the second Excel
file in the folder that is modified today & copy range (A1:A75) values
from the Data Worksheet of the second file & paste them in Range
(B1:B75) of the new file.
3) .. and so, i.e. copy Range(A1:A75) from each of the excel files
modified today & place is sequentially in ranges (C1:C75), (D175)
etc of the new file
4) Name and save this new file with the name "Batchfile" and place it
in the same folder.

Your help would be greatly appreciated.

TIA

Vinay

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can excel run a batch file? Tom Excel Discussion (Misc queries) 2 June 1st 09 02:46 AM
Excel from Batch File Problem PcolaITGuy Excel Discussion (Misc queries) 2 January 10th 08 06:43 PM
Excel to Run a Batch File?!? carla New Users to Excel 3 January 20th 07 02:32 AM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM
Running a batch file from Excel VBA verizon Excel Programming 1 July 20th 03 09:27 AM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017