Mega Code Archive
Categories
/
VisualBasic Script
/
Excel
XlTemplate Saves Document As A template
Sub save() ActiveWorkbook.SaveAs Filename:="\\server2\Public\Building Schedule.xls", _ FileFormat:=xlTemplate End Sub