Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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), (D1:D75) 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel run a batch file? | Excel Discussion (Misc queries) | |||
Excel from Batch File Problem | Excel Discussion (Misc queries) | |||
Excel to Run a Batch File?!? | New Users to Excel | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
Running a batch file from Excel VBA | Excel Programming |