Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud
HypSetAliasTable() sets the alias table for the selected worksheet.
HypSetAliasTable (ByVal vtSheetName As Variant, ByVal vtAliasTableName As Variant)
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.
0 if successful; otherwise, returns the appropriate error code.
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