HypSetAliasTable

Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud

Description

HypSetAliasTable() sets the alias table for the selected worksheet.

Syntax

HypSetAliasTable (ByVal vtSheetName As Variant, ByVal vtAliasTableName As Variant)

Parameters

vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtAliasTableName: The text name of the alias table. vtAliasTableName is of the form “Default”, “Long Names” and so forth.

Return Value

0 if successful; otherwise, returns the appropriate error code.

Example

Public Declare Function HypSetAliasTable Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtAliasTableName As Variant) As Long
Sub Example_SetAliasTable
sts = HypSetAliasTable(Empty,"Long Names")
End sub