This documentation is archived and is not being maintained.

Address Cell (Hyperlinks Section)

Office 2007

Specifies a URL address, DOS file name, or UNC path to which to jump.

You can specify Address as a relative path based on the base path defined for the document in the Hyperlink base field on the Summary tab of the Properties dialog box (File menu). If the document has no base path, the application navigates based on the document path. If the document has not been saved, the hyperlink is undefined.

Remarks

You can also set the value of the Address cell in the Hyperlinks dialog box (Insert menu).

To get a reference to the Address cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

Hyperlink.name.Address
where Hyperlink.name is the name of the hyperlink row

To get a reference to the Address cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionHyperlink

Row index:

visRow1stHyperlink + i
where i = 0, 1, 2...

Cell index:

visHLinkAddress



Show: