press alt+F8 in excel
or Tools -> Macro -> Macros
Macro name : CombineTextFiles
Create
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: http://excel.tips.net
http://support.microsoft.com/kb/141689
Thursday, October 01, 2009
Importing Multiple Files to a Single Workbook
Subscribe to:
Posts (Atom)