Describes the Oracle Smart View for Office VBA function, HypListUserVariables.

Cloud data provider types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting


HypListUserVariables() returns the list of user variable names associated with an application.


HypFunctionName(vtFriendlyName, vtDimensionName, vtUserVariableName, vtMemberName) As Long

ByVal vtFriendlyName As Variant

ByVal vtDimensionName As Variant

ByVal vtUserVariableName As Variant

ByVal vtMemberName As Variant


vtFriendlyName: The friendly connection name of the data provider.

vtDimensionName: In the list of user variables returned, gets the corresponding dimension name to which each user variable belongs.

vtUserVariableName: The names of the user variable.

vtMemberName: Gets the corresponding member name set for each user variable in the list.

Return Value

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


Sub ListUserVariables()
 Dim userVarList As Variant 'to get list of user variable names
 Dim dimList As Variant  'to get corresponding dimension name for which each user variable belongs to in the list
 Dim mbrList As Variant  'to get corresponding member name set for each user variable in the list
 sts = HypListUserVariables("connectionName", dimList, userVarList, mbrList)
End Sub