how to save only one sheet as workbook
 

Dear All,

I have workbook with sheets: sheet1, sheet2, sheet3.
I want to save this workbook in three workbooks. First workbook should have
only one sheet (sheet1), second workbook should have only one sheet (sheet2)
and third should have also one sheet (sheet3) and workbooks names I would
like to have sheet1, sheet2, sheet3 as well.
How I can do this manually and in VBA (if I have many sheets in essential
workbook)

Best wishes,
Lado

how to save only one sheet as workbook
 

Thank you,

This works fine.

Best,
Lado

"Norman Jones" wrote in message
...
Hi Lado,

Addressing the programming solution, try:

Sub Tester()
Dim WB As Workbook
Dim WS As Worksheet

Set WB = ActiveWorkbook

For Each WS In WB.Worksheets
WS.Copy
ActiveWorkbook.SaveAs WS.Name
Next WS

End Sub

This will save each sheet of the workbook as a new single-sheet workbook
bearing the name of the original sheet.


---
Regards,
Norman



"Kiknadze Lado" wrote in message
...
Dear All,

I have workbook with sheets: sheet1, sheet2, sheet3.
I want to save this workbook in three workbooks. First workbook should
have
only one sheet (sheet1), second workbook should have only one sheet
(sheet2)
and third should have also one sheet (sheet3) and workbooks names I
would
like to have sheet1, sheet2, sheet3 as well.
How I can do this manually and in VBA (if I have many sheets in
essential
workbook)

Best wishes,
Lado

how to save only one sheet as workbook
 

Hi Lado,

Addressing the programming solution, try:

Sub Tester()
Dim WB As Workbook
Dim WS As Worksheet

Set WB = ActiveWorkbook

For Each WS In WB.Worksheets
WS.Copy
ActiveWorkbook.SaveAs WS.Name
Next WS

End Sub

This will save each sheet of the workbook as a new single-sheet workbook
bearing the name of the original sheet.


---
Regards,
Norman



"Kiknadze Lado" wrote in message
...
Dear All,

I have workbook with sheets: sheet1, sheet2, sheet3.
I want to save this workbook in three workbooks. First workbook should
have
only one sheet (sheet1), second workbook should have only one sheet
(sheet2)
and third should have also one sheet (sheet3) and workbooks names I would
like to have sheet1, sheet2, sheet3 as well.
How I can do this manually and in VBA (if I have many sheets in essential
workbook)

Best wishes,
Lado