Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

HYPERLINK Function

Last modified: January 16, 2012

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Example 4

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

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.

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.

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

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

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

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

Show:
© 2015 Microsoft