Set o = CreateObject(class)| class | (Variant) uses the syntax ServerName.TypeName: 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:
This script 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.
Dim oExcelApp, oWorkbook, oSheetSet oExcelApp = CreateObject("Excel.Application")oExcelApp.Visible=trueSet oWorkbook = oExcelApp.WorkBooks.AddSet oSheet = oExcelApp.Sheets(1)oSheet.Cells(1,1) = oWorkbook.Sheets.CountoSheet.Cells(1,2) = 34oSheet.Cells(2,1) = NowoSheet.SaveAs "C:\Data\Test.xls"oExcelApp.QuitDim oWordSet oWord = CreateObject("Word.Basic")oWord.AppShowoWord.FileOpen "C:\Data\Test.doc"oWord.Insert "" & vbNewLineoWord.FileSaveDim oIESet oIE = CreateObject("InternetExplorer.Application.1")oIE.Visible = trueoIE.Navigate "https://www.promotic.eu"