How can I convert an excel file into a .txt file for multiple tabs in the workbook?

Hi all,

I have an excel spreadsheet that formats the file and creates a txt file and sends it to a folder. how can I update it to do that for multiple tabs in the workbook instead of just sheet 1? also how can I tell it to name the file the same as the tab name?

attached is what I have so far...

Please Login or Register  to view this content.

Give this a try:

Please Login or Register  to view this content.