Accessing Other Object Models

On the whole, the functionality of WSH is strictly limited. For instance, WSH itself provides almost no access to the filesystem, nor does it support any application services. This is a deliberate omission; the designers of Windows Script Host intended that you could draw on the functionality of other object models when writing WSH scripts.

The "hooks" into other object models are provided by the WScript object's CreateObject andGetObject methods; the former method creates a new instance of an object, while the latter retrieves a reference to an existing instance. As Table 7-30 shows, using these methods, you can instantiate objects like the following:

Active Directory Service Interface (ADSI)

ADSI provides a single set of directory service interfaces for managing network resources.

ActiveX Data Objects (ADO)

ADO is a data access technology that offers a uniform methodology for accessing data regardless of location or format. ADO has a relatively "flat" object model, and many objects (like the Recordset object, or the Connection object) can be instantiated independently of one another.

Collaborative Data Objects (CDO)

CDO is an object model that uses MAPI to create mail-enabled applications. The Session object is its top-level object.

Data Access Objects (DAO)

DAO is a data access technology intended primarily for use with Access databases and the Jet database engine. Its top-level object is named DBEngine.

The Dictionary object

A part of the Scripting Runtime Library, theDictionary object provides access to data sets that have identifiable keys.

The Excel Application object

The Excel object model is useful for extracting data from spreadsheets or for manipulating charts. Its top-level object is the Application object.

The FileSystemObject object

A part of the Scripting Runtime Library, the FileSystemObject provides access to the local filesystem.

Windows Management Instrumentation (WMI)

WMI is Microsoft's implementation of Web-Based Enterprise Management (WBEM), a technology that aims at standardizing access to management information in an enterprise environment.

The Word Application object

The Word object model makes it easy to manipulate Word .doc files as well as Rich Text Format (.rtf) files. Note that its top-level object is the Application object.

Table 7-30. Some object models and their programmatic identifiers

Object

ProgID

Description

Access

Access.Application

The forms and reports (primarily) of an Access table

Connection

ADODB.Connection

An ADO database connection

DBEngine

DAO.DBEngine

The DAO object model, primarily for Access databases

Dictionary

Scripting.Dictionary

A high-performance alternative to arrays and collections for keyed data

Excel

Excel.Application

The Microsoft Excel application, for manipulating spreadsheets and charts

FileSystemObject

Scripting.FileSystemObject

Represents the local filesystem

Recordset

ADODB.Recordset

An ADO recordset

Session

MAPI.Session

A Session object using Collaborative Data Objects (CDO)

SWbemLocator

WbemScripting.SWbemLocator

A WMI object that provides access to WMI on a particular local or remote host computer

SWbemObjectPath

WbemScripting.SWbemObjectPath

A WMI object that constructs and validates object paths

SWbemServices

winmgmts:

A WMI object whose InstancesOf method provides access to WMI class instances

Word

Word.Application

The Microsoft Word application for manipulating documents

Категории