VBScript Objects

VBScript Objects

1)

Object Name: File System Object

Purpose: It is Used to work with Drives, Folders and Files in Computer environment

How to Create:
Set Variable = CreateObject (“Scripting.FileSystemObject”)

Note: Set is VBScript statement, CreateObject is VBScript built-in Function, (“Scripting.FileSystemObject”) is Class value

--------------------------------------------------------------
2)

Object Name: Excel Application Object

Purpose: It is used to perform operations on Excel Application /Excel File

How to Create:
Set Variable = CreateObject (“Excel.Application”)

--------------------------------------------------------------
3)

Object Name: Word Application Object

Purpose: It is used to perform operations on Word Application /Word document

How to Create:
Set Variable = CreateObject (“Word.Application”)

--------------------------------------------------------------
4)

Object Name: Database Connection Object

Purpose: It is used to connect to databases, any database, connection string only vary from one database to another.

How to Create:
Set Variable = CreateObject (“Adodb.Connection”)

--------------------------------------------------------------
5)

Object Name: Database Recordset Object

Purpose: It is used to perform operations on Database Tables (Records)

How to Create:
Set Variable = CreateObject (“Adodb.Recordset”)

--------------------------------------------------------------

6)

Object Name: Database Command Object

Purpose: The Database Command object is used to perform actions like creating, adding, retrieving, deleting or updating records.
 

How to Create:
Set Variable = CreateObject (“Adodb.Command”)

--------------------------------------------------------------

7) 

Object Name: Dictionary Object

Purpose: It is used to define Key, value pairs

How to Create:
Set Variable = CreateObject (“Scripting.Dictionary”)

0 comments:

Post a Comment