Saves the open workbook named Schedule.xls under the name Building Schedule.xls in the folder named \\server2\Public using the "Microsoft Excel 97-2003 & 5.0/95" format (from Excel 2003):

 
Sub save()
    ActiveWorkbook.SaveAs Filename:="\\server2\Public\Building Schedule.xls", _
            FileFormat:=xlExcel9795
End Sub

1.	xlNormal: Saves Document As A normal workbook
2.	xlXMLSpreadsheet: Saves Document As An XML spreadsheet
3.	xlWebArchive Saves Document As A single file web page
4.	xlHtml Saves Document As A web page
5.	xlTemplate Saves Document As A template
6.	xlExcel9795 Saves Document As An Excel workbook for Excel versions 95 and later
7.	Save the active workbook
8.	Saving a Workbook That Has Already Been Saved
9.	Saving All Open Workbooks

Saves the open workbook named Schedule.xls under the name Building Schedule.xls in the folder named \\server2\Public using the "Microsoft Excel 97-2003 & 5.0/95" format (from Excel 2003): : Workbook SaveAs « Excel « VBA / Excel / Access / Word