Save the active workbook : Workbook SaveAs « Excel « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » Excel » Workbook SaveAs 
Save the active workbook
 
Sub save()
    ActiveWorkbook.SaveAs FileName:="Salaries.xls"
End Sub

 
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.xlExcel9795 Saves Document As An Excel workbook for Excel versions 95 and later
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
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.