| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save an entireworkbook to individual text files?
I regularily work with workbooks that contain well over 20 worksheets per
book. After working with the data I always have to save each 'sheet' as an individual *.txt file. All the sheets are saved using the worksheet name. Is there any way to automate this process, ie. save all worksheets to a respective *.txt file. For example, 20 sheets in a book, will result in 20 seperate *.txt files. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an individual page in a workbook? | Excel Worksheet Functions | |||
| MACRO HELP: Save All Sheets To Individual Workbooks | Excel Discussion (Misc queries) | |||
| Create individual files from a row | Excel Discussion (Misc queries) | |||
| Help importing text files into individual cells | Excel Discussion (Misc queries) | |||
| How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) | |||
Threaded Mode
