This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Specifies a location within the target document to link to.
For example, for a given Hyperlink element:
- If the http://msdn.microsoft.com/en-us/library/aa166988(v=office.10) Address element is "Drawing1.vsd", the SubAddress element can specify a page name such as "Page-3".
- If the Address element is the Microsoft Excel file "Samples.xls", the value of this element can be a worksheet or range within a worksheet, such as "Worksheet Functions" or "Sheet1!A1:D10".
- If the Address element is "http://www.microsoft.com/visio/", the value of this element can be a named anchor within the document, such as "solutions".
Optional string. Represents a unit of measure. The default is STR. For details about STR, see http://msdn.microsoft.com/en-us/library/aa218417(v=office.10) Units of measure.
Optional string. Represents the element's formula. This attribute can contain the string "someFormula" if the formula exists locally, "No Formula" if the formula is locally deleted or blocked, or "Inh" if the formula is inherited.
If the attribute is not present, the element's formula is a simple constant, for example, <element> 5 </element>.
Optional string. Indicates that the formula evaluates to an error. The value of Err is the current value (an error message string); the value of the element is the last valid value.
The SubAddress element is relevant only when contained in a http://msdn.microsoft.com/en-us/library/aa191981(v=office.10) DocumentSheet, http://msdn.microsoft.com/en-us/library/aa203159(v=office.10) PageSheet, or http://msdn.microsoft.com/en-us/library/aa203207(v=office.10) Shape element. It is ignored when contained in a http://msdn.microsoft.com/en-us/library/aa203205(v=office.10) StyleSheet element.
http://msdn.microsoft.com/en-us/library/aa157630(v=office.10) SubAddress cell (Hyperlinks section)