Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only current sheet
I have a workbook with multiple sheets (one for each month) which is a
rather large file. I'm trying to find a way to save only the current worksheet to a file (i.e., eliminate all sheets but the current one). I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the sheets. Is there a way to do this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only current sheet
Export your worksheet to another workbook and save them.
-----Original Message----- I have a workbook with multiple sheets (one for each month) which is a rather large file. I'm trying to find a way to save only the current worksheet to a file (i.e., eliminate all sheets but the current one). I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the sheets. Is there a way to do this. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only current sheet
To do it manually:
rightclick on the worksheet to save, select "move or copy". make it go to a new workbook (and choose copy at the bottom) Save that new workbook. If you need a macro, record it when you do it manually once. Jerry Park wrote: I have a workbook with multiple sheets (one for each month) which is a rather large file. I'm trying to find a way to save only the current worksheet to a file (i.e., eliminate all sheets but the current one). I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the sheets. Is there a way to do this. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only current sheet
Dave Peterson wrote:
To do it manually: rightclick on the worksheet to save, select "move or copy". make it go to a new workbook (and choose copy at the bottom) Save that new workbook. If you need a macro, record it when you do it manually once. Jerry Park wrote: I have a workbook with multiple sheets (one for each month) which is a rather large file. I'm trying to find a way to save only the current worksheet to a file (i.e., eliminate all sheets but the current one). I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the sheets. Is there a way to do this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving sheet data to another sheet automatically | Excel Worksheet Functions | |||
Saving only current worksheet into new file | Excel Discussion (Misc queries) | |||
Saving file as current month name automatically | Excel Discussion (Misc queries) | |||
Saving current worksheet on cell value change | New Users to Excel | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) |