Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create different workbooks from only one workbook
I have one workbook with 15 sheets. I want Excel to generate one separate
workbook from each sheet in the book. Is this possible? Thanks in advance Regards, Emece.- |
#2
|
|||
|
|||
You can try
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Emece" wrote in message ... I have one workbook with 15 sheets. I want Excel to generate one separate workbook from each sheet in the book. Is this possible? Thanks in advance Regards, Emece.- |
#3
|
|||
|
|||
Emece
You can use a macro. Sub Make_New_Books() Dim w As Worksheet Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In ActiveWorkbook.Worksheets w.Copy ActiveWorkbook.SaveAs FileName:=ThisWorkbook.Path & "\" & w.Name ActiveWorkbook.Close Next w Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Thu, 29 Sep 2005 07:51:17 -0700, "Emece" wrote: I have one workbook with 15 sheets. I want Excel to generate one separate workbook from each sheet in the book. Is this possible? Thanks in advance Regards, Emece.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I split worksheets from one workbook into individual workbooks | Excel Discussion (Misc queries) | |||
How can I create an XML map (2003) to import to workbook | Excel Worksheet Functions | |||
import multiple workbooks into 1 workbook | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Create invoices from excel workbook | Excel Worksheet Functions |