Setting properties

You access server properties for an OLE control through its Object property using the following syntax:

olecontrolname.Object.{ serverqualifiers.}propertyname

If the OLE object is complex, there could be nested objects or properties within the object that serve as qualifiers for the property name.

For example, the following commands for an Excel spreadsheet object activate the object and set the value property of several cells:

double value
ole_1.Activate(InPlace!)
ole_1.Object.cells[1,1].value = 55
ole_1.Object.cells[2,2].value = 66
ole_1.Object.cells[3,3].value = 77
ole_1.Object.cells[4,4].value = 88

For an Excel 95 spreadsheet, enclose the cells’ row and column arguments in parentheses instead of square brackets. For example:

ole_1.Object.cells(1,1).value = 55

For properties of an OLEObject variable, the server qualifiers and property name follow the variable name:

oleobjectvar.{ serverqualifiers.}propertyname