Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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