Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a new file for each excel worksheet
I have an excel file with many worksheets (tabs). I now need each sheet to
be its own file with its own name. Is there any way to just "right click" on the worksheet and paste it into a new file? Or, do I have to do it the long way, and open each sheet, and copy the cells before pasting into the new file. I have a lot of them! Thanks ! -- sherry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a new file for each excel worksheet
"sherry" wrote in message
... I have an excel file with many worksheets (tabs). I now need each sheet to be its own file with its own name. Is there any way to just "right click" on the worksheet and paste it into a new file? Or, do I have to do it the long way, and open each sheet, and copy the cells before pasting into the new file. I have a lot of them! Thanks ! -- sherry You can right-click the worksheet tab and use "Move or Copy". This gives you the option of moving (or copying) the worksheet to another workbook. The alternative is to open the original workbook, delete all worksheets except one, and use "Save As" to save the remaining worksheet as a new workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a new file for each excel worksheet
try this
Sub splitsheets() For Each ws In Worksheets ws.Copy ActiveWorkbook.SaveAs Filename:="C:\yourfoldername\" & ws.Name & ".xls" ActiveWorkbook.Close Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "sherry" wrote in message ... I have an excel file with many worksheets (tabs). I now need each sheet to be its own file with its own name. Is there any way to just "right click" on the worksheet and paste it into a new file? Or, do I have to do it the long way, and open each sheet, and copy the cells before pasting into the new file. I have a lot of them! Thanks ! -- sherry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a new file for each excel worksheet
See also this page
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "sherry" wrote in message ... I have an excel file with many worksheets (tabs). I now need each sheet to be its own file with its own name. Is there any way to just "right click" on the worksheet and paste it into a new file? Or, do I have to do it the long way, and open each sheet, and copy the cells before pasting into the new file. I have a lot of them! Thanks ! -- sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an Excel Worksheet Glossary | Excel Discussion (Misc queries) | |||
Creating folders and subfolders from excel file list | Excel Discussion (Misc queries) | |||
Need help with creating a text file via excel | Excel Worksheet Functions | |||
Excel Creating Temporary File After Saving | Excel Discussion (Misc queries) | |||
Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) |