Mega Code Archive
Categories
/
VisualBasic Script
/
Excel
XlWebArchive Saves Document As A single file web page
Sub save() ActiveWorkbook.SaveAs Filename:="\\server2\Public\Building Schedule.xls", _ FileFormat:=xlWebArchive End Sub