Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Saves the open workbook named Schedule xls under the name Building Schedule xls in the folder named server2Public using the Microsof
Sub save()
    ActiveWorkbook.SaveAs Filename:="\\server2\Public\Building Schedule.xls", _
            FileFormat:=xlExcel9795
End Sub