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.