After you create an instance of an object, you are ready to set its properties and execute its methods. You can talk to the object through the object variable you created. Using this object variable, you can get and set properties and execute methods.
The objects you will be talking to through automation all have properties.
Properties are the attributes of the objectthe adjectives you use to describe the objects. You can use VBA to inquire about the properties of objects and set the values of these properties. Here are some examples:
objExcel.Visible = True objExcel.Caption = "Hello World" objExcel.Cells(1, 1).Value = "Here I Am"
Each of these examples sets properties of the Excel application object. The first example sets the Visible property of the object to True. The second example sets the Caption of the object to "Hello World". The final example sets the Value property of the Cells object, contained within the Excel object, to the value "Here I Am".
Properties refer to the attributes of an object, and
methods refer to the actions you take on the object. Methods are the verbs that apply to a particular object type. Here's an example:
objExcel.Workbooks.Add
This code uses the Add method to add a workbook to the Excel object.