Episode 894 - Export Each Worksheet

Rod sends in today's question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod's problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!