The Application object is the Default Object, Excel assumes it even when it is not specified. Excel objects are accessed through 'parent' objects - Worksheet is the parent of the Range Object, and the Workbook is the parent of the Worksheet object, and the Application object is the parent of the Workbook object.Įxample - the following code line inserts the text "Hello" in the cell A1 of the worksheet named Sheet1 of the workbook named ExcelVBA.xlsm: The entire Excel application is represented by the Application Object which is at the top of the Excel object hierarchy and moving down you can access the objects from Application to Workbook to Worksheet to Range (Cells) and further on, by connecting the objects with a period (dot).
The Object Model of the Application (Excel) refers to and contains its programming objects which are related to each other in a hierarchy. The object model is a large hierarchy of all the objects used in VBA. While writing vba code in Microsoft Office Excel, you will be using the objects provided by the Excel object model. If the host application is the Microsoft Word application, the Application Object refers to and represents the Word application.Īll applications like Excel, Access, Word or PowerPoint, which use VBA, have their own object model. The Application Object refers to the host application of Excel, and the entire Excel application is represented by it. Properties & Methods of the Application Object - when it is not required to specify the Application qualifier
Instances where using the Application qualifier is required to be used for Properties or Methods of the Application object Excel VBA Application Object, Properties & MethodsĮxcel VBA Workbook Object, working with Workbooks in ExcelĮxcel VBA Range Object, Referencing Cells and Ranges
0 kommentar(er)
