Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook
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 -------- www.coffeecozy.co Use your Bodum and give up cold coffee for good! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook
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 ============================= chequer - ExcelForums.com wrote in message ... I am working on a workbook that has 5 sheets. If I want to save the finished results, the Result sheet, I want to do so without saving the whole workbook. The only way I have found of doing this is to open another workbook and make it into a template to Copy and Paste (special) the results to. This is pretty complicated especially as those that will be using the program know less than I do. If this is the only way I can do it, is it possible to ‘call up’ this template from within the program workbook ?. I had no trouble when I originally wrote the program in Qbasic, and am only trying to rewrite it with excel as Dos based programs have had it Unfortunately I have no ideas re Macros --------- www.coffeecozy.com Use your Bodum and give up cold coffee for good! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook
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) "chequer - ExcelForums.com" wrote in message ... I am working on a workbook that has 5 sheets. If I want to save the finished results, the Result sheet, I want to do so without saving the whole workbook. The only way I have found of doing this is to o pen another workbook and make it into a template to Copy and Paste (special) the results to. This is pretty complicated especially as those that will be using the program know less than I do. If this is the only way I can do it, is it possible to ‘call up’ this template from within the program workbook ?. I had no trouble when I originally wrote the program in Qbasic, and am only trying to rewrite it with excel as Dos based programs have had it Unfortunately I have no ideas re Macros --------- www.coffeecozy.com Use your Bodum and give up cold coffee for good! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |