1.

Solve : COPY EXCEL FILE.?

Answer»

Hi Everybody!!

I have 15 files of excel and each of them contains data on sheet 1.
I have to do a copy of all filles data in single sheet.

Any HELP..?

Thanks
Jay
This needs to be done with a script where you can create an instance of Excel, open each workbook, and copy the data on sheet1 to a new workbook.

The BEST DOS can do is a bulk merge of the workbooks. You might check out the scripts at Office Scripts for some ideas.

Good luck. My hunch is it's going to be easier and quicker just to go ahead and manually do this. or last OPTION, using external party software?
hereJayanand, this is a PROGRAMMING problem. Ussually it is solved in Visual Basic, but you can do it in other languages as well.
I do not know any sollutions, even with a programming language Quote from: Sidewinder on April 02, 2007, 06:19:23 AM

The best DOS can do is a bulk merge of the workbooks.

Thanks!!

The option copy, copy a.xls+a1.xls like i tried it didn't work.
Bulk merge !! how ??
Is any dos command for excel to edit?
I know you have solution in a MINUTE through vbscript.

The links given by ghostdog74 is useful.

Thans n Regards,
Jay
Quote from: Jayanand on April 03, 2007, 04:14:12 AM
does the command work for word excel?


Discussion

No Comment Found

Related InterviewSolutions