Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

XlHtml Saves Document As A web page

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