Home | Advertising Info102 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Sunday, August 20, 2017  


VBscript Built-in Functions

Back to Function List

CreateObject

Produces and Gives a reference to an Automation Object

CreateObject(class)

The class argument uses the syntax servername.typename and has these parts:

Part Description
servername The name of the application providing the object.
typename The type or class of the object to create.
Automation servers provide at least one type of object. For example, a word-processing application may provide an application object, a document object, and a toolbar object. To create an Automation object, assign the object returned by CreateObject to an object variable: Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Sheet") This code starts the application creating the object ( in this case, a Microsoft Excel spreadsheet). Once an object is created, you refer to it in code using the object variable you defined. In the following example, you access properties and methods of the new object using the object variable, ExcelSheet, and other Excel objects, including the Application object and the Cells collection. For example: ' Make Excel visible through the Application object. ExcelSheet.Application.Visible - True ' Place some text in the first cell of the sheet. ExcelSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.DOC" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit ' Release the object variable. Set ExcelSheet = Nothing



   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright 1998 - 2017 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com