| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
export sheets to multiple new files
I have a workbook with several worksheets (30) and am trying to find a way to
save each worksheet in the book as a new excel file using the name of the worksheet as the new file name...I use the move or copy regularly, but was hoping to avoid having to type the names for each worksheet inorder to save them? Thanks for your help! Tanya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export Excel data as multiple files | Excel Discussion (Misc queries) | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Saving Sheets into Multiple Files | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
Threaded Mode
