Creating subtotals in Excel from ABL

After a lot of research, trial and error, and general head-banging, I've come up with the formula to add subtotals to a range in an Excel spreadsheet, but I can't for the life of me put those subtotals into more than one column.
This is the syntax for subtotals on a single column:
xlwksheet:range(vrange):subtotal(1, -4157, 4).
xlwksheet is the worksheet object.
vrange is a text string containing the range in CR:CR format.
1 causes the subtotal to occur at each change in the first column of the range.
-4157 indicates the subtotal is to be a sum.
4 indicates that the subtotal is performed against the fourth column of the range.

The three optional parameters are not used.
In the documentation, the third parameter can be "Array(4,6, 7, 8)" and cause the subtotals to be applied to the fourth, sixth, seventh, and eighth columns of the range. I can't come up with a way to alter this element to a form that is acceptable to Progress.

In addition to the answer to my problem, I would also appreciate knowing where one can find this information. Pressing F1 in the COM object viewer in ProTools is just not doing it for me. I'm working in Progress 9.1E.

Thanks --

R. Sommo


Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
redskienz's picture

Try Object Browser

Hi,

If your looking for MS Excel constants, properties, methods,etc..

Open your MS Excel-> Alt-F11 -> F2.

Object Browser: Object BrowserObject Browser: Object Browser
object Browser

I'm not so sure if the object browser is what you need, hope this helps

gSanchez


Thanks - I'm familiar with

Thanks - I'm familiar with the object browser, just can't figure out the syntax for this particular parameter in Progress.


Excel SubTotals Collapse Group

I have some code that can do this - first time here will try to add the file

It does sub-totals and even collapses excel groups

(The excel part of code is mine... the rest of p code is from previous employees.)

Richard


AttachmentSize
pobyjob.p30.07 KB

Excel Sub Totals Collapse Group

Hi
Many thanks for the sample program. It has proved very useful.

Regards

Granville