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)
HypGetRowCount() returns the number of row dimensions.
Note: | It is assumed that a call has already been made to HypGetSourceGrid to initialize the dynamic link query, which contains the information about the active data provider and the grid on the worksheet. |
HypGetRowCount()
Returns number of row dimensions if successful; otherwise, returns the appropriate error code.
Declare Function HypGetRowCount Lib "HsAddin" () As Long Sub Example_HypGetRowCount() Dim vtGrid As Variant Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic") Sts = HypRetrieve(Empty) Range ("B2").Select Sts = HypGetSourceGrid (Empty, vtGrid) Sts = HypGetRowCount () End sub