Greetings, it's been forever since I've used vba in Excel so please bear with me, plus I really don't know how to search to see if my question has been answered already. I have a zillion text files being exported from an old unix system. They all have the same name "textdump". But they need to be imported into Excel and they each have different file layouts. Since I'm using test data right now, the day will come soon that i'll need to start importing the real data. I imported the test data manually. I have all of the file layouts. Is there a way to programmatically import these files into Excel based on a function where I can pre-set the delimeters, the field names and data types, then run a macro or whatever to find d:\textdump and import it. If the dumped file is from GCUST1 then I have a function named GCUST1, etc. Tall order probably. Would appreciate any thoughts you have on this idea. Thank you very much in advance.