Workbook

[chequer - ExcelForums.com]

I am working on a workbook that has 5 sheets
If I want to save the finished results, the Result sheet, I want to d
so without saving the whole workbook
The only way I have found of doing this is to open another workboo
and make it into a template to Copy and Paste (special) the result
to
This is pretty complicated especially as those that will be using th
program know less than I do
If this is the only way I can do it, is it possible to ‘call up’ thi
template from within the program workbook ?

I had no trouble when I originally wrote the program in Qbasic, and a
only trying to rewrite it with excel as Dos based programs have ha
i
Unfortunately I have no ideas re Macro

 

[R.VENKATARAMAN]

normally it is not possible to save only one sheet. waht you can do it copy
the sheet in anothyer workbook and save.


try this code given by Frank Arendt-Theilen in this newsgroup(taken from my
notes)


Sub SaveOnlyOneSheet()
Dim SheetName As String
SheetName = InputBox(Prompt:="What's the new file name:", _
Title:="File name")
If SheetName = "" Then GoTo Ende
ActiveSheet.Copy
ActiveWorkbook.SaveAs SheetName
ActiveWorkbook.Close
Exit Sub
Ende:
MsgBox "Error, file name not valid!", vbCritical, "Error"
End Sub
=============================

 

[Bob Phillips]

You don't need this template.

turn on the macro recorder.
right-click the sheet tab
select Move or Copy
tick the Create a copy box
select your sheet from the list
in the To book list select (new book)
ok out
save the new workbook
stop the recorder

You then have a macro to do it.

--

HTH

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