Using OLE object commands in macros

Commands for OLE objects are called methods, and they perform tasks on an OLE object in a specific OLE Automation server.

OLE object methods are specific for each object, such as “Excel.Application” or “Excel.Workbooks.”

OLE object methods that return information about an object are called properties. Many properties have parameters as well as return values. In addition, many properties can be assigned a value, like the name of a variable, by placing them on the left-hand side of the assignment symbol “:=”.

Using OLE object commands in macros