E
Ezequiel
Guest
I'm using SubTotal in a Openedge generated Excel book for my first time.
The example of the KB (Progress KB - Sample Code to do Excel Grouping) is: chWorksheet:Range("A1"):CurrentRegion:Subtotal(1, -4112, 2, True, False, False).
The parameters for SubTotal are: GroupBy , Function:, TotalList, Replace:, PageBreaks:, SummaryBelowData:
In "TotalList" the example is 2, which means column 2 is totalized.
In VBA, TotalList can be an array. For example, Array(14, 15) indicates totaling columns 14 and 15.
But I can't make ABL to accept that. It only receives an integer, for one column. Which is sad.
Does anybody if it's possible to totalize more than one column?
Thank you
Continue reading...
The example of the KB (Progress KB - Sample Code to do Excel Grouping) is: chWorksheet:Range("A1"):CurrentRegion:Subtotal(1, -4112, 2, True, False, False).
The parameters for SubTotal are: GroupBy , Function:, TotalList, Replace:, PageBreaks:, SummaryBelowData:
In "TotalList" the example is 2, which means column 2 is totalized.
In VBA, TotalList can be an array. For example, Array(14, 15) indicates totaling columns 14 and 15.
But I can't make ABL to accept that. It only receives an integer, for one column. Which is sad.
Does anybody if it's possible to totalize more than one column?
Thank you
Continue reading...