Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypRetrieve() retrieves data from the database.
Essbase only: HypRetrieve does not support creating a multiple-grid worksheet. Use HypRetrieveRange instead.
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypRetrieve Lib "HsAddin" (ByVal vtSheetName As Variant) As Long Sub Example_HypRetrieve() X=HypRetrieve(Empty) End Sub Public Declare Function HypRetrieve Lib "HsAddin" (ByVal vtSheetName As Variant) As Long Sub Example_HypRetrieve() X=HypRetrieve(Empty) If X = 0 Then MsgBox("Retrieve successful.") Else MsgBox("Retrieve failed.") End If End Sub