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