Thanks for the great code equiangular.

That worked perfect, but is there a way to prompt once for the
locations to save the new text files or create the text files in the
same directory as the
original excel file.