MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening Multiple Comma separated files

Posted by harish shelat on April 20, 2001 9:11 AM

Is there any way i can write a macro which will automatically open 24 comma separated file.
For example i have file on my c:\Temp\3a.txt,5a.txt,220a.txt,5b.txt,55f.txt etc.
I like to convert them into excel sheet.

Posted by Barrie Davidson on April 20, 2001 9:13 AM

Take a look at 13754.html