| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save One sheet
You can use the Copy method of the Worksheet object to copy a
single sheet to a new workbook. Worksheets("Sheet1").Copy Once this line of code is executed, the new workbook will be the ActiveWorkbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Spencer Hutton" wrote in message ... is it possible to save just one sheet of a workbook in it's own new workbook? i have a workbook with 3 sheets in it. how can i copy sheet1 to a new workbook, and save it under the filename "savedbook". TIA. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| How to save only row changes to a new sheet | Excel Discussion (Misc queries) | |||
| save as w/sheet | Excel Discussion (Misc queries) | |||
| Save sheet? | Excel Worksheet Functions | |||
| Save sheet as .txt | Excel Programming | |||
Linear Mode
