sundarsree
05-03-2010, 07:17 AM
Dear ol...
I need a requirement in excel VBA in which i need to combine n number of workbooks(having only one sheet each) in a particular location or folder in to a single MASTER workbook that too in an single sheet. The data should be appended in the file name order.. like 1.xls,2.xls,....etc
Is there any VBA code available for this scenario....?
Pls Help at the earlist.
I need a requirement in excel VBA in which i need to combine n number of workbooks(having only one sheet each) in a particular location or folder in to a single MASTER workbook that too in an single sheet. The data should be appended in the file name order.. like 1.xls,2.xls,....etc
Is there any VBA code available for this scenario....?
Pls Help at the earlist.