Exporting Worksheets from a workbook and saving them as a .prn file

[Ayobami Adeloye]

i have over 200 worksheets with different names on a workbook. I would
like to move each worksheet to a separate workbook, and save the
workbook as a formatted text (space delimited) file i.e a .prn file
using the same name it had as a worksheet in the original workbook to
a any specified folder.

This way i would have 200 worksheets in the original workbook saved as
different .prn files in the specified folder all at the click of a
button.

Would really appreciate any help guys.

Thanks in anticipation