| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open New Workbook / Save and Close Current Workbook
I would like to created a script to open the new workbook that I created. Also in the script to save and close the active workbook. Listed below are the parameters that I used to create the new workbook. Thanks so much for the help. With ActiveSheet 'New PRINT ORDERS Sheet in New Workbook .Parent.SaveAs Filename:=ActWkbk.Path & "\" & "SEND_MAJORS_" & _ ".xls" '' Format(Now, "yyyyddmmhhmmss") & ".xls" ' .Parent.Close savechanges:=False End With |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open New Workbook / Save and Close Current Workbook
You would have to run your code from a personal workbook. If you try to run
it from the active workbook, it will stop when you close the active workbook. "Joe K." wrote: I would like to created a script to open the new workbook that I created. Also in the script to save and close the active workbook. Listed below are the parameters that I used to create the new workbook. Thanks so much for the help. With ActiveSheet 'New PRINT ORDERS Sheet in New Workbook .Parent.SaveAs Filename:=ActWkbk.Path & "\" & "SEND_MAJORS_" & _ ".xls" '' Format(Now, "yyyyddmmhhmmss") & ".xls" ' .Parent.Close savechanges:=False End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fix code - check to see if a workbook is open, if so, save changes then close. | Excel Programming | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| Close a the current workbook and load another specified workbook | Excel Programming | |||
| Close current Workbook after calling macro in other | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Linear Mode
