| 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. |
| 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) | |||
Threaded Mode
