Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a worksheet out of a workbook
Excel 2000
Is there a programming statement that will save a worksheet out of a workbook to a new filename? Application.ActiveWorkbook.Sheet4.SaveCopyAs ("Coffee-A.xls") The foregoing statement fails because the SaveCopyAs method only supports worksbooks, not worksheets. Thanks for any help. Fred Holmes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a worksheet out of a workbook
Check out the Worksheet.Copy method. Note that "...If you don't specify
either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet." (and ONLY the copied sheet). You would then probably want to loop through the Workbook collection, find the new "Book x" and then save it with a specific file name. Alternatively, use something like (aircode) 'Create a new workbook, keeping a handle to it. Set wkb = Workbooks.Add ' Copy a sheet to the new workbook MyWorksheet.Copy Befo=wkb.Worksheets("Sheet 1") ' (Optionally delete all sheets in the new Workbook except the one you just copied) ' (Do this AFTER you copy since a workbook must have at least one sheet) ' Give the new workbook a name by saving it. wkb.SaveAs Filename:= "MyNewFile.xls" HTH, George Nicholson Remove 'Junk' from return address. "Fred Holmes" wrote in message ... Excel 2000 Is there a programming statement that will save a worksheet out of a workbook to a new filename? Application.ActiveWorkbook.Sheet4.SaveCopyAs ("Coffee-A.xls") The foregoing statement fails because the SaveCopyAs method only supports worksbooks, not worksheets. Thanks for any help. Fred Holmes |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a worksheet out of a workbook
ActiveWorkbook.Sheet4.Copy ActiveWorkbook.SaveAs Filename:="Coffee-A.xls" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Fred Holmes" wrote in message ... Excel 2000 Is there a programming statement that will save a worksheet out of a workbook to a new filename? Application.ActiveWorkbook.Sheet4.SaveCopyAs ("Coffee-A.xls") The foregoing statement fails because the SaveCopyAs method only supports worksbooks, not worksheets. Thanks for any help. Fred Holmes |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a worksheet out of a workbook
Marvelous. The "Copy" method is just what I was looking for.
Thanks, Fred Holmes On Tue, 15 Jun 2004 14:18:22 -0500, "George Nicholson" wrote: Check out the Worksheet.Copy method. Note that "...If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet." (and ONLY the copied sheet). You would then probably want to loop through the Workbook collection, find the new "Book x" and then save it with a specific file name. Alternatively, use something like (aircode) 'Create a new workbook, keeping a handle to it. Set wkb = Workbooks.Add ' Copy a sheet to the new workbook MyWorksheet.Copy Befo=wkb.Worksheets("Sheet 1") ' (Optionally delete all sheets in the new Workbook except the one you just copied) ' (Do this AFTER you copy since a workbook must have at least one sheet) ' Give the new workbook a name by saving it. wkb.SaveAs Filename:= "MyNewFile.xls" HTH, George Nicholson Remove 'Junk' from return address. "Fred Holmes" wrote in message .. . Excel 2000 Is there a programming statement that will save a worksheet out of a workbook to a new filename? Application.ActiveWorkbook.Sheet4.SaveCopyAs ("Coffee-A.xls") The foregoing statement fails because the SaveCopyAs method only supports worksbooks, not worksheets. Thanks for any help. Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a Worksheet/Workbook with VALUES ONLY | Excel Discussion (Misc queries) | |||
Saving into 1 workbook as a different worksheet | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
When saving workbook only the first worksheet gets saved. | Excel Worksheet Functions | |||
Saving one specific worksheet in a workbook | Excel Programming |