| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO HELP: Save All Sheets To Individual Workbooks
I have a workbook with a around 40 worksheets in it. I would like to save
each individual sheet to an individual workbook in a named location hopefully following a naming convention, i.e: c\documents and settings\zorro\my documents\My Project\workbookname_sheet1.xls, ....sheet2.xls, ...sheet3.xls etc. Hope you can help Zorro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro to Save Copy of File to New Location | Excel Discussion (Misc queries) | |||
| Newbie seeks suggestion on recording new macro to print sheets | New Users to Excel | |||
| macro for new sheets | Excel Worksheet Functions | |||
| calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) | |||
| How to automatic calculation and macro execution between 3 workbooks? | Excel Worksheet Functions | |||
Threaded Mode
