WorkbookBase.LinkInfo Method
Gets the link date and update status.
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 Function LinkInfo ( _
name As String, _
linkInfoArgument As XlLinkInfo, _
type As Object, _
editionRef As Object _
) As Object
public Object LinkInfo(
string name,
XlLinkInfo linkInfoArgument,
Object type,
Object editionRef
)
Parameters
name
Type: System.StringThe name of the link.
linkInfoArgument
Type: Microsoft.Office.Interop.Excel.XlLinkInfoOne of the XlLinkInfo values that specifies the type of information to return.
type
Type: System.ObjectOne of the XlLinkInfoType values that specifies the type of link to return information for.
editionRef
Type: System.ObjectIf the link is an edition, this parameter specifies the edition reference as a string in R1C1 style. EditionRef is required if there is more than one publisher or subscriber with the same name in the workbook.
Return Value
Type: System.Object
A value that indicates information about the link. If LinkInfoArgument is xlUpdateState, this method returns 1 if the link updates automatically, or 2 if the link must be updated manually.
Remarks
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
Examples
The following code example uses gets the collection of DDE/OLE links in the current workbook, and then uses the LinkInfo method to determine whether or not each DDE/OLE link updates automatically or manually.
This example is for a document-level customization.
Private Sub WorkbookLinkInfo()
' Get the collection of DDE/OLE links in the workbook.
Dim Links As Array = _
CType(Me.LinkSources(Excel.XlLink.xlOLELinks), _
Array)
' If there are DDE/OLE links, then display how each link
' updates.
If Links IsNot Nothing Then
Dim i As Integer
For i = 1 To Links.Length
Dim UpdateValue As Integer = Me.LinkInfo(Links(i), _
Excel.XlLinkInfo.xlUpdateState, _
Excel.XlLinkInfoType.xlLinkInfoOLELinks)
If UpdateValue = 1 Then
MsgBox(Links(i) & " link updates automatically.")
ElseIf UpdateValue = 2 Then
MsgBox(Links(i) & " link updates manually.")
End If
Next i
Else
MsgBox("The workbook contains no DDE/OLE links.")
End If
End Sub
private void WorkbookLinkInfo()
{
// Get the collection of DDE/OLE links in the workbook.
Array links = (Array)this.LinkSources(Excel.XlLink.xlOLELinks);
// If there are DDE/OLE links, then display how each link
// updates.
if (links != null)
{
for (int i = 1; i <= links.Length; i++)
{
string linkName = (string)links.GetValue(i);
int updateValue = (int)this.LinkInfo(linkName,
Excel.XlLinkInfo.xlUpdateState,
Excel.XlLinkInfoType.xlLinkInfoOLELinks);
if (updateValue == 1)
{
MessageBox.Show(linkName + " link updates automatically.");
}
else if (updateValue == 2)
{
MessageBox.Show(linkName + " link updates manually.");
}
}
}
else
{
MessageBox.Show("The workbook contains no DDE/OLE links.");
}
}
.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.