The cross post is here : http://www.excelforum.com/excel-prog...ml#post2101480
Hi,

I thank you all very much for helping so many days. I need your help again on this.
I have 25 text files say A,B,C,D,E etc in a folder and I have one master excel file with 5 sheets called Master file,Data,Groups,Total, and Price.
Wha I do now manually is I insert one sheet called A in my master file and open text file A when I open that file it open as text so I convert that to text to columns

I want to automate this process.. that is get all the 25 files from a folder to the masterfile in each sheet with converted text into to colums.

However I got a similar code in Ronderbruins site
but that will get file in a different workbook. i want the data to get in the same workbook
http://www.rondebruin.nl/txtcsv.htm

Regards
Arvind