Macros Doubt
 

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

Macros Doubt
 

Check out the below link

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

--
Jacob


"Royal" wrote:

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