Macros Doubt

[Royal]

Hi All,

I need to create a Macro which will append 'n' no.of excels/excel sheets
into one excel file.

Example : a.xls, b.xls and c.xls using a macro I need combine all together
into d.xls

Note : I have 25K rows in each excel sheet. And all together the final excel
should have more than 1lac rows. hence it will support only in office 2007.

Please provide me your valuable feedback.

Thanks

 

[Jacob Skaria]

Check out the below link

http://www.rondebruin.nl/copy3.htm