Save workbook and close : Workbook « 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
VBA / Excel / Access / Word » Excel » Workbook 




Save workbook and close
 
Sub CloseWorkbook()
   Dim myWorkbook1 As workBook
 
   Set myWorkbook1 = Workbooks.Open(Filename:="E:\SalesData.xls")
   Range("A1").Value = Format(Date, "ddd mmm dd, yyyy")
   Range("A1").EntireColumn.AutoFit
   myWorkbook1.Close SaveChanges:=True
End Sub

 














Related examples in the same category
1.Center workbook
2.Create a new workbook
3.Creates a new workbook and adds it to the collection, reads the number of workbooks into a variable, and selects all worksheets in the active workbook:
4.Get workbook format
5.To close all open workbooks, use the Close method of the Workbooks collection object.
6.To close a single workbook, use the Close method of the Workbook object. The Close method accepts three optional arguments (SaveChanges, FileName, and RouteWorkbook).
7.To save a workbook from a VBA program, use either the Save methods of the Workbook object.
8.To select the last Workbook object in the collection
9.Activate work book
10.Use a String rather than an index value to reference a workbook
11.The Workbooks property is a member of the Application object and returns a reference to the Workbook object specified by the index value given in the parentheses.
12.Open workbook by name
13.Close a workbook and save it
14.Create a workbook and save it as a new file
15.The distinction between the Workbook and Window objects lies in an additional method that can be used to create a Window object
16.Open a workbook and then size it to fit just within the application window
17.Use Application object to save a workbook as a new file
18.Add a new workbook and save it
19.arranges the open workbooks in a tiled configuration
20.maximizes any workbook when it is activated
21.places the username in the footer of each sheet printed:
22.Check Whether a Workbook Is Open
23.Check Whether a Sheet in an Open Workbook Exists
24.Count the Number of Workbooks in a Directory
25.Controlling Worksheet Visibility
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.