SourceItem Property

Applies To

Bound Object Frame Control, Unbound Object Frame Control.

Description

You can use the SourceItem property to specify the data within a file to be linked when you create a linked OLE object.

Setting

You can set the SourceItem property by specifying data in units recognized by the application supplying the object. For example, when you link to Microsoft Excel, you specify the SourceItem property setting using a cell or cell-range reference such as R1C1 or R3C4:R9C22 or a named range such as Revenues.

Note To determine the syntax to describe a unit of data for a particular object, see the documentation for the application that created the object.

You can set this property using the property sheet, a macro, or Visual Basic.

In Visual Basic, you set this property using a string expression.

Remarks

The control’s OLETypeAllowed property must be set to Linked or Either when you use this property. Use the control’s SourceDoc property to specify the file to link.

See Also

Action Property, Class Property, OLEType Property, OLETypeAllowed Property, SourceDoc Property.

Example

See the Action property example.