Hello All,

Please help me to get out of this.

Iam trying to add the contents of one excell sheet to another.

Iam USING Copy command at cmd prompt and it says copying success.

But when i really check the same by going to Excell it shows file as corrupted.

What i need is to add two excell sheets A1.xls and B1.xls to C1.xls.

Thanks in advance
Raj

Try doing this within Excel using a series of copy/paste operations. Excel FILES use a proprietary structure. The best the batch copy command can do is physically copy the files but not merge the logical structure of an Excel workbook.

8-)Thanks for timely reply,

But my problem is like this we are recieveing these two excell sheets from some other company as a report.

And we need to combine the same for our accounting department people.

Currently iam mergeing them manaully where as my boss wants it to be done using some script.

Help is greatly appreciated

RajTry recording a macro in Excel. This will at least eliminate some of the drudgery of this task.

"DOS" is text based so you could export each of the incoming xls files as csv files. Now your "DOS" copy command will WORK (copy A+B C) and then import the resulting file back into Excel.

A VBScript would work ALSO but you really haven't given us ENOUGH information about the incoming workbooks or the resulting workbook.

Good luck. 8-)