HYPERLINK function

Microsoft Office ShapeSheet

HYPERLINK function

Navigates to the specified address, which can be a DOS, UNC, or URL path.

Syntax

HYPERLINK("address"[,"subaddress","extrainfo",window,"frame"])

address

A full path or a relative path based on the Hyperlink base field specified in the Properties dialog box (click Properties on the File menu).

subaddress

Optional string. Specifies a location within address to link to. For example, if address is a Microsoft Visio file, subaddress can be a page name; if a Microsoft Excel file, subaddress can be a worksheet or range within a worksheet; if a URL for an HTML page, subaddress can be an anchor.

extrainfo

Optional string. Passes information used in resolving the URL, such as the coordinates of an image map.

window

Optional argument. Specifies whether the hyperlink is opened in a new window. The default value is FALSE.

frame

Optional string. Specifies the name of a frame to target when Visio is open as an Active document in an ActiveX browser, such as Microsoft Internet Explorer 3.0 or later. The default is an empty string.

Remarks

If the document has no base path, Visio navigates according to the document path. If the document hasn't been saved, the hyperlink is undefined.

You can use the GOTOPAGE function to navigate to pages of a document.

Example 1

HYPERLINK("C:\My Documents\Drawing1.vsd")

Example 2

HYPERLINK("\\Server\Share\Drawing1.vsd")

Example 3

HYPERLINK("http://www.microsoft.com")

Example 4

HYPERLINK("..\data.xls","sheet1!A1")