| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO HELP: Save All Sheets To Individual Workbooks
Try this example Zorro
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Zorro" wrote in message k... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO HELP: Save All Sheets To Individual Workbooks
Many thanks Ron. It worked a treat. I saved the macro to my personal
workbook first (mistake). Now I have made a template for my monthly sales pivot table report with your macro in it. The original sales report with the pivot table was too heavy for my pocket pc (at 5mb!) so I needed to split it up (via Show Pages command in the pivot table) into manageable chunks. My ppc can now cope with the 900kb files. Thanks Zorro "Ron de Bruin" wrote in message ... Try this example Zorro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Zorro" wrote in message k... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO HELP: Save All Sheets To Individual Workbooks
Hi Zorro
You can add the macro in your personal.xls if you want Change Set WbMain = ThisWorkbook To Set WbMain = ActiveWorkbook -- Regards Ron de Bruin http://www.rondebruin.nl "Zorro" wrote in message k... Many thanks Ron. It worked a treat. I saved the macro to my personal workbook first (mistake). Now I have made a template for my monthly sales pivot table report with your macro in it. The original sales report with the pivot table was too heavy for my pocket pc (at 5mb!) so I needed to split it up (via Show Pages command in the pivot table) into manageable chunks. My ppc can now cope with the 900kb files. Thanks Zorro "Ron de Bruin" wrote in message ... Try this example Zorro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Zorro" wrote in message k... 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 |
| Reply |
| 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 | |||
Linear Mode
