Thread: Macros Doubt
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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