Workbook.UpdateLinks Property (2007 System)
Gets or sets a value that indicates a workbook's setting for updating embedded OLE links.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Property UpdateLinks As XlUpdateLinks
'Usage
Dim instance As Workbook
Dim value As XlUpdateLinks
value = instance.UpdateLinks
instance.UpdateLinks = value
public XlUpdateLinks UpdateLinks { get; set; }
public:
property XlUpdateLinks UpdateLinks {
XlUpdateLinks get ();
void set (XlUpdateLinks value);
}
public function get UpdateLinks () : XlUpdateLinks
public function set UpdateLinks (value : XlUpdateLinks)
Property Value
Type: XlUpdateLinks
One of the XlUpdateLinks values.
Examples
The following code example uses the UpdateLinks property to display how embedded OLE links are updated in the workbook.
This example is for a document-level customization.
Private Sub DisplayLinkUpdateType()
Select Case Me.UpdateLinks
Case Excel.XlUpdateLinks.xlUpdateLinksAlways
MsgBox("Links will always be updated.")
Case Excel.XlUpdateLinks.xlUpdateLinksNever
MsgBox("Links will never be updated.")
Case Excel.XlUpdateLinks.xlUpdateLinksUserSetting
MsgBox("Links will update according " & _
"to the user settting.")
End Select
End Sub
private void DisplayLinkUpdateType()
{
switch (this.UpdateLinks)
{
case Excel.XlUpdateLinks.xlUpdateLinksAlways:
MessageBox.Show("Links will always be updated.");
break;
case Excel.XlUpdateLinks.xlUpdateLinksNever:
MessageBox.Show("Links will never be updated.");
break;
case Excel.XlUpdateLinks.xlUpdateLinksUserSetting:
MessageBox.Show("Links will update according " +
"to the user settting.");
break;
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.