View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe K. Joe K. is offline
external usenet poster
 
Posts: 41
Default Automatic Open Created Spreadsheet


Please help me create a script to save and close my current spreadsheet and
open
the new spreadsheet (MATERIAL_SHIIPPING_ORDERS).

Listed below is the script to create the new spreadsheet.

Thank so much for the help.

With ActiveSheet
.Parent.SaveAs Filename:=ActWkbk.Path & "\" &
"MATERIAL_SHIIPPING_ORDERS_.xls"
End With