Export (0) Print
Expand All
Expand Minimize

<SubAddress> element

<SubAddress> element

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 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".

Syntax

<SubAddress
    [Unit = "unitval"]
    [F = "formula"]
    [Err = "error"]> 
</SubAddress>

Attributes

Unit

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.

F

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>.

Err

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.

Element information

Parent elements:

http://msdn.microsoft.com/en-us/library/aa167617(v=office.10) Hyperlink

Child elements:

None

Remarks

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.

See also

Show:
© 2014 Microsoft