Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
I have, as part of a project, a print form I want to save as a separate file
without losing focus on the original. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
On May 5, 12:12*pm, vbnewbie
wrote: I have, as part of a project, a print form I want to save as a separate file without losing focus on the original. Can anyone help? I'm not exactly sure how you want the data to be copied, but there is sample code below of how to copy the active sheet to a new workbook and open the save as dialog box to save the newly created workbook. Best, Matthew Herbert Sub SaveWorksheet() Dim Wks As Worksheet Dim wksCopy As Worksheet Dim Wkb As Workbook Dim strFileName As String Set Wks = ActiveSheet Set Wkb = Workbooks.Add 'copy the worksheet to a new workbook Wks.Copy After:=Wkb.Sheets(Wkb.Sheets.Count) 'save the file strFileName = Application.GetSaveAsFilename() If strFileName Then Wkb.SaveAs strFileName End If End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
What's a "print form" ?
To do what your subject line implies, simply ActiveSheet.Copy This will create a new file, save it as required, and close it. Regards, Peter T "vbnewbie" wrote in message ... I have, as part of a project, a print form I want to save as a separate file without losing focus on the original. Can anyone help? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
This should get you started:
http://www.rondebruin.nl/copy6.htm Post back if you have specific questions. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Peter T" wrote: What's a "print form" ? To do what your subject line implies, simply ActiveSheet.Copy This will create a new file, save it as required, and close it. Regards, Peter T "vbnewbie" wrote in message ... I have, as part of a project, a print form I want to save as a separate file without losing focus on the original. Can anyone help? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
"ryguy7272" wrote: This should get you started: http://www.rondebruin.nl/copy6.htm Post back if you have specific questions. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Peter T" wrote: What's a "print form" ? To do what your subject line implies, simply ActiveSheet.Copy This will create a new file, save it as required, and close it. Regards, Peter T "vbnewbie" wrote in message ... I have, as part of a project, a print form I want to save as a separate file without losing focus on the original. Can anyone help? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a worksheet in a project as a SEPARATE FILE
Ryan
Really Useful - Thankyou! my problem is no longer a problem Cheers Pete "ryguy7272" wrote: This should get you started: http://www.rondebruin.nl/copy6.htm Post back if you have specific questions. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Peter T" wrote: What's a "print form" ? To do what your subject line implies, simply ActiveSheet.Copy This will create a new file, save it as required, and close it. Regards, Peter T "vbnewbie" wrote in message ... I have, as part of a project, a print form I want to save as a separate file without losing focus on the original. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save part of a worksheet in a separate file? | Excel Worksheet Functions | |||
Save filtered data as a separate file | Excel Programming | |||
Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
Cannot save Project file as MS Access file | Excel Discussion (Misc queries) | |||
How to save each sheet as a separate excel-file | Excel Programming |