Microsoft KB Archive/85808

= Microsoft Knowledge Base =

Excel: GET.LINK.INFO Works Only with DDE Links
Last reviewed: September 23, 1997

Article ID: Q85808

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0
 * Microsoft Excel for OS/2, version 3.0

SUMMARY
The Microsoft Excel function, GET.LINK.INFO, only returns a value if the link referred to is a DDE link in Windows or OS/2, or if the link is a Publisher\Subscriber link on the Macintosh.

MORE INFORMATION
The GET.LINK.INFO function will return #N/A when used on any link other than a DDE link. For example, if you use this function to try and obtain information pertaining to a link that exists between a Microsoft Excel worksheet and a Microsoft Excel chart, or two Microsoft Excel worksheets, #N/A will be returned. However, if you use this function on DDE links that exist between Microsoft Excel and another program, a 1 or 2 will be displayed.

For information about creating a Visual Basic, Applications Edition, equivalent to GET.LINK.INFO, do the following:


 * 1) In Microsoft Excel version 5.0, choose Contents from the Help menu.
 * 2) Choose the Reference Information Topic.
 * 3) Under General Reference, choose the Microsoft Excel Macro Functions Contents topic.
 * 4) Choose the Visual Basic Equivalents For Macro Functions And Commands topic.

The macro commands in this topic are listed in alphabetical order.