Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

XlXMLSpreadsheet

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