Hi, Would you please help me fix my macro? I'm using 97 Excel with Vista Windows. I am attempting to convert a directory of text files to Excel files formatted in a certain fashion. It is stopping after I open the first text file. Do yo uhave any suggestions? Thanks.