Wednesday, February 18, 2015

How to Merge Many XLS Files into One File



How to Merge Many XLS Files into One File?
It will combine many xls files into a single spreadsheet file including the worksheet!
Just create new XLS File Then press Alt+F11 to go to Microsoft Visual Basic Mode
Double Click ThisWorkbook on the left column


Copy paste the code below in the right text box column
 

Press F5 There you go.
If you have 4 sheets, just change the 2nd line:
Const NUMBER_OF_SHEETS = 3

Into:
Const NUMBER_OF_SHEETS = 4

http://superuser.com/questions/304899/how-can-i-merge-hundreds-of-excel-spreadsheet-files

1 comment: