This is a problem with excel. Whenever you open  a file  after setting text  to
columns, excel will apply the same text to columns  split for everything
thereafter whether using vba or not. The best thing is to add another step at
the end of your loop  which resets text to columns before looping to the next
file.