xlExcel9795 Saves Document As An Excel workbook for Excel versions 95 and later : Workbook SaveAs « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Workbook SaveAs

xlExcel9795 Saves Document As An Excel workbook for Excel versions 95 and later

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








Related examples in the same category

1.xlNormal: Saves Document As A normal workbook
2.xlXMLSpreadsheet: Saves Document As An XML spreadsheet
3.xlWebArchive Saves Document As A single file web page
4.xlHtml Saves Document As A web page
5.xlTemplate Saves Document As A template
6.Save the active workbook
7.Saves the open workbook named Schedule.xls under the name Building Schedule.xls in the folder named \\server2\Public using the "Microsoft Excel 97-2003 & 5.0/95" format (from Excel 2003):
8.Saving a Workbook That Has Already Been Saved
9.Saving All Open Workbooks