| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
export multiple sheets to multiple excel files
I have a workbook with approx 30 sheets. I am trying to figure out how to
save each sheet as it's own workbook (using the name of the worksheet as the file name) without having to go through the save as dialog box for each tab.... Thanks for any help you can give me! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
export multiple sheets to multiple excel files
See answer in your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tanya" wrote in message ... I have a workbook with approx 30 sheets. I am trying to figure out how to save each sheet as it's own workbook (using the name of the worksheet as the file name) without having to go through the save as dialog box for each tab.... Thanks for any help you can give me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| export sheets to multiple new files | Excel Discussion (Misc queries) | |||
| Export Excel data as multiple files | Excel Discussion (Misc queries) | |||
| Automated multiple text files into multiple sheets in one workbook | 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) | |||
Linear Mode
