Save a single sheet from a workbook

  • Thread starter Thread starter JAMES T.
  • Start date Start date
J

JAMES T.

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
 
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)
 
Sure. Choose Edit/Move or Copy Sheet and copy the sheet to a new
workbook. Save the workbook.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Saving / emailing sinlge excel sheet, not entire workbook 2
e-mailing a single Sheet 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Saving a worksheet 2
Excel Move or Copy Stopped Working? 0
Need to merge worksheets - Excel 2003 0
Excel 2003 1

Back
Top