View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe K. Joe K. is offline
external usenet poster
 
Posts: 41
Default 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