| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet save
Looks like sheet dont have save property. I dont want to save the entiire
workbook but Just one sheet(sheet1). How is that possible ? Thx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
worksheet save
one way:
Public Sub CopySheetToNewWorkbook() Sheets("Sheet1").Copy Application.DisplayAlerts = False With ActiveWorkbook .SaveAs Filename:="test.xls" .Close End With Application.DisplayAlerts = True End Sub In article , "vbastarter" wrote: Looks like sheet dont have save property. I dont want to save the entiire workbook but Just one sheet(sheet1). How is that possible ? Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save only active worksheet without save all of worksheet | Excel Worksheet Functions | |||
| When you hit Save on a template, how can you save as worksheet? | Excel Worksheet Functions | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| Save worksheet to a CD | New Users to Excel | |||
| Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions | |||
Linear Mode
