Table of contents
TOC
Collapse the table of content
Expand the table of content

ObjectFrame.OLETypeAllowed Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

You can use the OLETypeAllowed property to specify the type of OLE object a control can contain. Read/write Byte.

Syntax

expression. OLETypeAllowed

expression A variable that represents an ObjectFrame object.

Remarks

The OLETypeAllowed property uses the following settings.

SettingConstantDescription
LinkedacOLELinkedThe control can contain only a linked object.
EmbeddedacOLEEmbeddedThe control can contain only an embedded object.
EitheracOLEEither(Default) The control can contain either a linked or an embedded object.

Note For unbound object frames and charts , you can't change the OLETypeAllowed setting after an object is created. For bound object frames, you can change the setting after the object is created. Changing the OLETypeAllowed property setting only affects new objects that you add to the control.

To determine the type of OLE object a control already contains, you can use the OLEType property.

Example

The following example creates a linked OLE object using an unbound object frame named OLE1 and sizes the control to display the object's entire contents when the user clicks a command button.

Sub Command1_Click 
 OLE1.Class = "Excel.Sheet" ' Set class name. 
 ' Specify type of object. 
 OLE1.OLETypeAllowed = acOLELinked 
 ' Specify source file. 
 OLE1.SourceDoc = "C:\Excel\Oletext.xls" 
 ' Specify data to create link to. 
 OLE1.SourceItem = "R1C1:R5C5" 
 ' Create linked object. 
 OLE1.Action = acOLECreateLink 
 ' Adjust control size. 
 OLE1.SizeMode = acOLESizeZoom 
End Sub

See also

Concepts

ObjectFrame Object

© 2017 Microsoft