VBA: GetGLDrilldownSummary

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:56 PM by Gabriel Michaud

Applies to:

Velixo Classic
Velixo NX (when used with Excel on Desktop)

Important: Visual Basic for Applications macros are not supported by Excel Online.

Purpose

Returns a summary of all the summary rows identified during drilldown.

See Introduction to Velixo's VBA functions for general usage information.

Syntax

  objVelixo.GetGLDrilldownSummary Cell

objVelixo - a variable that represents an instance of the Velixo VBA functions class.

Parameters

Name	Description
Cell	Required. Excel.Range to act upon. Must be a single cell.

Remarks

Returns a list of GLDrilldownSummary objects. The following properties are available in this object: Account, Branch, Connection, Ledger, SourceAddress Subaccount.

This function can be used to create your own custom drilldown tab, or to dynamically expand a report based on the selected row. A complete example can be found in this file: RapidByte Macros Sample.xlsm

Example

Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")

If Selection.Cells.Count > 1 Then
    MsgBox "Only one cell can be selected at once.", vbCritical
    Exit Sub
End If

For Each data In velixoObj.GetGLDrilldownSummary(ActiveCell)      
    MsgBox data.Account & "-" & data.Subaccount 
Next