Open workbook by name : Workbook « Excel « VBA / Excel / Access / Word

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

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Photoshop Tutorials

Flash Tutorials

3ds-Max Tutorials

Illustrator Tutorials

C# / CSharp Tutorial

C# / CSharp Open Source

ASP.NET Tutorial

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML CSS Reference

Python Tutorial

Python Open Source

SQL Server / T-SQL

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

VB.Net Tutorial

Flash / Flex / ActionScript

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Excel » Workbook

Open workbook by name


 



Sub Array2()

  Dim Data As Variant, myWorkbook As Workbook

  Dim i As Integer



  Data = Array("A", "B", "C", "D")

  For i = LBound(Data) To UBound(Data)

    Set myWorkbook = Workbooks.Open(FileName:=Data(i) & ".xls")

    MsgBox myWorkbook.Name

    myWorkbook.Close SaveChanges:=True

  Next i

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.	Save workbook and close
12.	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.
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

www.java2java.com | Contact Us

Copyright 2009 - 12 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.