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
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