Hello,
My Scenario is as follows:

Folder_PATH: 2007\NOV\06
(Daily one folder gets created dynamically via batch file and places three files (A,B,C) in XLS format)

In 06 Folder: I have three Files with three sheets in each
File: A (with sheet1,sheet2,sheet3)
File: B (with sheet1,sheet2,sheet3)
File: C (with sheet1,sheet2,sheet3)

All the sheets in the files headers are same i.e Sheet1!A (Header) = Sheet1!B (Header)

So my basic requirement is

File: D consisting of [sheet1(file A, file B, file C))

All the data in the files A/B/C of sheet 1 would consolidate in to file D of sheet1.

Kindly help me with the Batch file script please.

Thanks
Chandu

what do you need help with?Hey,
I need the batch file or script for doing this. If you provide me the script or the solutions for this according to the scenario then I would use it for my CURRENT scenario.

Kindly make it please

Thanks
ChanduExcel files are automation objects. While batch commands can manipulate the ENTIRE XLS files (move/copy/del) they cannot GET inside the XLS files to process the information on individual workbooks and worksheets.

You would need to use a Windows Script language that can deal with automation objects such as VBScript, JScript, REXX, or Python.

Try CHECKING out the Windows Script Center for more information.