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)
HypGetSourceGrid() creates a query from the source grid for the dynamic link query.
This function applies to both static and dynamic link views.
Before you run HypGetSourceGrid, a connected grid must exist on the active worksheet and a valid data cell must be selected.
HypGetSourceGrid(vtSheetName, vtGrid)
ByVal vtSheetName As Variant
ByRef vtGrid As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtGrid: The grid XML returned
Returns 0 if successful or the appropriate error code otherwise.
Declare Function HypGetSourceGrid Lib "HsAddin" (ByVal vtSheetName As Variant, ByRef vtGrid As Variant) As Long Sub Example_HypGetSourceGrid() Dim vtGrid As Variant Range ("B2").Select Sts = HypGetSourceGrid (Empty, vtGrid) End sub