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 Comments
Leave a Reply. |