Table 22 lists the constants defined in ESSXLVBA.TXT. You can use them in functions, such as EssVGetMemberInfo and EssVZoomIn, that require you to specify an outline level as a parameter.
Table 22. VBA Level Constants
Constant | Value | Description |
---|
EssChildLevel | 1 | Next level |
EssDescendentLevel | 2 | All levels |
EssBottomLevel | 3 | Bottom level |
EssSiblingLevel | 4 | Sibling level |
EssSameLevel | 5 | Same level |
EssSameGenerationLevel | 6 | Same generation |
EssCalculationLevel | 7 | Calc level |
EssParentLevel | 8 | Previous or parent level |
EssDimensionLevel | 9 | Dimension member belongs to |