CreateObjectWS

CreateObjectWS is a function in the Windows Script Host (WSH) that allows scripts to create and manipulate COM objects. It is a part of the WSH object model and is used primarily in VBScript and JScript to interact with various COM components. The function takes two parameters: the ProgID or CLSID of the COM object and an optional parameter that specifies the server where the object should be created.

The syntax for CreateObjectWS is as follows:

CreateObjectWS(progID, serverName)

progID is a string that specifies the ProgID or CLSID of the COM object to be created. serverName is an optional string that specifies the name of the server where the object should be created. If this parameter is omitted, the object is created on the local machine.

CreateObjectWS returns a reference to the created COM object, which can then be used to call its methods and properties.

One common use of CreateObjectWS is to create instances of Microsoft Office applications such as Excel or Word. For example, the following VBScript code creates an instance of Excel and adds a new worksheet:

Set objExcel = CreateObjectWS("Excel.Application")

Set objWorkbook = objExcel.Workbooks.Add

Set objWorksheet = objWorkbook.Worksheets.Add

It is important to note that CreateObjectWS is not available in all versions of WSH. It was introduced in Windows 2000 and is not available in Windows 95 or Windows 98. Additionally, it requires that the COM object being created is registered on the target machine.

In summary, CreateObjectWS is a powerful function in WSH that allows scripts to create and manipulate COM objects. It is particularly useful for automating tasks in Microsoft Office applications and other COM-based applications. However, it is important to be aware of its limitations and requirements.