Bound Object Frame Control, Chart Control, Unbound Object Frame Control.
You can use the SourceDoc property to specify the file to be linked or embedded when you create a linked object or embedded object using the Action property in Visual Basic.
For an embedded object, enter the filename for the file you want to use as a template and set the Action property to acOLECreateEmbed.
For a linked object, enter the full path and filename for the file to be linked and set the Action property to acOLECreateLink.
You can set this property using the property sheet, a macro, or Visual Basic.
Note While this property appears in the property sheet, it takes effect only when used with the Action property in Visual Basic.
You can use the SourceDoc property to specify the file to be linked and the control’s SourceItem property to specify the data within that file. If you want to link the entire object, leave the SourceItem property blank.
When a linked unbound object is created, the control’s SourceItem property setting is concatenated with its SourceDoc property setting. In Form view, Datasheet view, and Print Preview, the control’s SourceItem property setting is a zero-length string (" "), and its SourceDoc property setting is the full path to the linked file, followed by an exclamation point (!) or a backslash (\) and the SourceItem property setting as in the following example.
"C:\Work\Qtr1\Revenue.xls!R1C1:R30C15"
Action Property, Class Property, OLEType Property, OLETypeAllowed Property, SourceItem Property.
See the Action property example.