WorkbookBase.BreakLink Method

Converts formulas linked to other Microsoft Office Excel sources or OLE sources to values.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub BreakLink ( _
    name As String, _
    type As XlLinkType _
)

public void BreakLink(
    string name,
    XlLinkType type
)

Parameters

• name
  Type: System.String
  The name of the link.

• type
  Type: Microsoft.Office.Interop.Excel.XlLinkType
  One of the XlLinkType values. The type of link.

Examples

The following code example creates a link to another Excel workbook and then prompts the user to replace the link with the value of the link destination by using the BreakLink method. This example assumes that workbook Book2.xls exists at the root of the C directory.

This example is for a document-level customization.

Private Sub ConvertLinkToValue()
    Globals.Sheet1.Range("A1").FormulaR1C1 = _
        "='C:\[Book2.xls]Sheet1'!R2C2"

    If DialogResult.Yes = MessageBox.Show("Break the link?", _
        "Example", MessageBoxButtons.YesNo) Then
        Me.BreakLink("C:\Book2.xls", _
            Excel.XlLinkType.xlLinkTypeExcelLinks)
    End If
End Sub

private void ConvertLinkToValue()
{
    Globals.Sheet1.Range["A1", missing].FormulaR1C1 =
        @"='C:\[Book2.xls]Sheet1'!R2C2";

    if (DialogResult.Yes == MessageBox.Show("Break the link?", "Example",
        MessageBoxButtons.YesNo))
    {
        this.BreakLink(@"C:\Book2.xls",
            Excel.XlLinkType.xlLinkTypeExcelLinks);
    }
}

.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.

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace