Link

Inserts a labeled Link control into the spreadsheet. Link controls are conceptually similar to hypertext links in an HTML browser, providing a fast method for "jumping" between different spreadsheet cells on networked In-Sight devices. Links can be executed either manually by user input or automatically when referenced by a Select function. For more information, see Select.

Note:

To access the property sheet for a Link control, right-click the control and select Edit Function.
When using the Link function to log on to another system, the total execution time to process the Job on the target system could increase. When this execution time nears or exceeds the time between acquisition triggers, some triggers could be missed.

Link Inputs

Syntax: Link(Label,Host Name,Dialog Label/Cell,Cursor Position)

Parameter	Description
Label	The name of the Link control as it will appear in the spreadsheet.
Host Name	The network Host Name of the In-Sight sensor to which you would like to link. Leave this parameter blank when linking between locations within the same spreadsheet. For more information, see Network Settings Dialog. Note: When linking across the network, the User Name and Password of the active user must identically match an existing User Name and Password in the User List on the In-Sight sensor that is the link destination. For more information, see User Access Settings Dialog. If an invalid host name is specified, the connection may take up to 30 seconds to timeout.
Dialog Label / Cell	The Label of an existing Dialog or Wizard control that the Link will open, or a reference to the spreadsheet cell to show in the upper-left corner of the spreadsheet at the link destination. If a Label is specified for a Wizard control, the first dialog in the Wizard will automatically open when the Link control is executed. For more information, see Dialog and Wizard.
Cursor Position	A reference to the cell that will be highlighted at the link destination. Cursor Position is ignored if the Dialog Label parameter refers to a Wizard control. If the Dialog Label is valid, but the cell reference specified for the Cursor Position is not contained within that dialog, then executing the Link control still opens the dialog. If the Dialog Label is left unspecified or is invalid, then executing the Link control will jump to the Cursor Position (if defined) in the current spreadsheet. If neither the Dialog Label nor the Cursor Position are valid, then executing the Link control will jump to cell A0 in the current spreadsheet.

Link Outputs

Returns

A labeled Link control that "jumps" to the specified link location when executed.

Note: If the Link jumps to a valid Dialog or Wizard at the destination, closing or exiting that Dialog/Wizard will return you to the point of origin.

Link Example: Linking to a Cell in the Spreadsheet

Assume cell M2 is populated as follows:

M2 = Link("Jump","","","A5")

A Link control labeled "Jump" is displayed in cell M2:
Click the Link control to execute the function. The highlighted cursor jumps to cell A5. If cell A5 is not visible within the current view of the spreadsheet, the spreadsheet automatically repositions itself as necessary so that cell A5 is visible.

Example: Linking to a Cell in the Spreadsheet

Assume cell A2 is populated as follows:

A2 = Link("Jump","","J5","L9")

A Link control labeled "Jump" is displayed in cell A2:
Click the Link control to execute the function. The highlighted cursor jumps to cell L9, and the upper-left cell is J5.

Example: Linking to a Dialog in the Current Spreadsheet

Assume cell A2 is populated as follows:

A2 = Link("Jump","","Step 1","")

A Link control labeled "Jump" is displayed in cell A2:
Click the Link control to execute the function. The Dialog labeled "Step 1" in the current spreadsheet opens. If the dialog does not exist, then executing the Link control has no effect.

Example: Linking to a Dialog Across the Network

Assume cell A2 is populated as follows:

A2 = Link("Jump","is8402_010203","Step 1","")

A Link control labeled "Jump" is displayed in cell A2:

Click the Link control to execute the function. Executing the Link control initiates an automatic logon to the remote In-Sight host named "is8400_010203" (if allowed by the permissions defined in the User List dialog), where the Dialog labeled "Step 1" is opened. For more information, see User Access Settings Dialog.

Dismiss the dialog on the remote system, either by pressing the OK or Cancel buttons, to be restored back to the system from which the Link control was initiated.

Note: If the Link refers to a Wizard on the remote system instead of a Dialog, the connection will be restored to the initiating system only when the Finish or Cancel button is pressed.