Thursday, October 01, 2009

Importing Multiple Files to a Single Workbook

press alt+F8 in excel
or Tools -> Macro -> Macros
Macro name : CombineTextFiles

then save and goto excel and insert button from form for macro
then choose CombineTextFiles
after press button you can select files to import to excel refer: