Edit

HYPERLINK Function

  • Article

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

Syntax

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

Parameters

Name Required/Optional Data Type Description
address
Required
String
A full path or a relative path.
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
Boolean
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 has not been saved, the hyperlink is undefined.

Relative paths are based on the Hyperlink base field specified in the Visio Properties dialog box.

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

Example 1

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

Example 2

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

Example 3

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

Example 4

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