Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create workbooks from worksheets
Does anyone know an easy way to create multiple single-sheeted workbooks from
a single multi-sheeted workbook? What I am actually trying to do is create multiple csv files for data import from a workbook that contains many worksheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create workbooks from worksheets
Try some code like
Sub AAA() Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets WS.Copy Next WS End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ian in Ankara" wrote in message ... Does anyone know an easy way to create multiple single-sheeted workbooks from a single multi-sheeted workbook? What I am actually trying to do is create multiple csv files for data import from a workbook that contains many worksheets. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create workbooks from worksheets
See Ron de Bruin's code at
http://www.rondebruin.nl/copy6.htm "Ian in Ankara" wrote: Does anyone know an easy way to create multiple single-sheeted workbooks from a single multi-sheeted workbook? What I am actually trying to do is create multiple csv files for data import from a workbook that contains many worksheets. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create workbooks from worksheets
Works a treat. Thanks a lot!
Ian "Duke Carey" wrote: See Ron de Bruin's code at http://www.rondebruin.nl/copy6.htm "Ian in Ankara" wrote: Does anyone know an easy way to create multiple single-sheeted workbooks from a single multi-sheeted workbook? What I am actually trying to do is create multiple csv files for data import from a workbook that contains many worksheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many workbooks and worksheets can Excel understand? | Excel Discussion (Misc queries) | |||
Can I tile worksheets within a workbook, like one tiles workbooks. | Excel Discussion (Misc queries) | |||
Combine Workbooks as separate worksheets | Excel Discussion (Misc queries) | |||
Converting worksheets to workbooks. Is there an easy way? | Excel Discussion (Misc queries) | |||
Help! I need to create worksheets to connect? | Excel Worksheet Functions |