Save a single sheet from a workbook

Is there a way to save a single sheet from a workbook instead of saving
the whole book.

No. The best you can do is delete all the other sheets
and save the workbook under a new name.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Is there a way to save a single sheet from a workbook
instead of saving
>the whole book.
>
>.
>

You can do it with VBA

Sub SaveThis()
Dim sFilename As String
Activesheet.Copy
sFilename = Application.GetSaveAsFilename( _
fileFilter:="Excel Files (*.xls), *.xls")
If sFilename <> False Then
ActiveWorkbook.SaveAs sFilename
End If

End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jason Morin" <[email protected]> wrote in message
news:[email protected]...
> No. The best you can do is delete all the other sheets
> and save the workbook under a new name.
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >Is there a way to save a single sheet from a workbook
> instead of saving
> >the whole book.
> >
> >.
> >

Sure. Choose Edit/Move or Copy Sheet and copy the sheet to a new
workbook. Save the workbook.

In article <[email protected]>,
"JAMES T." <[email protected]> wrote:

> Is there a way to save a single sheet from a workbook instead of saving
> the whole book.