Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

OLEObjects.AutoLoad Property 

True if the OLE object is automatically loaded when the workbook that contains it is opened.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim oLEObjects1 As OLEObjects

Dim returnValue As Boolean
returnValue = oLEObjects1.AutoLoad

Dim sampleValue As Boolean
oLEObjects1.AutoLoad = sampleValue

bool AutoLoad {get; set;}
public boolean get_AutoLoad();
public void set_AutoLoad(boolean);
function get AutoLoad() : Boolean;
function set AutoLoad(Boolean);

This property is ignored by ActiveX controls. ActiveX controls are always loaded when a workbook is opened.

For most OLE object types, this property shouldn’t be set to True. By default, the AutoLoad property is set to False for new OLE objects; this saves time and memory when Microsoft Excel is loading workbooks. The benefit of automatically loading OLE objects is that, for objects that represent volatile data, links to source data can be reestablished immediately and the objects can be rendered again, if necessary.


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.