Need help in importing multiple text files to excel worksheet/s
Hi All,
I have the need import multiple text files located in single file folder to excel worksheets(preferably to multiple sheets). I have sperate text files with diffrent file names stored in one folder. I want to import them in to seperate excelsheets. Please let me know if this can be done. I am not an excel or VBA expert. Any help would be great.
Thanks
Eranda
Easiest way to do this is to
Easiest way to do this is to record a macro:
http://excelexperts.com/Learn-VBA-Record-a-Macro