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
Try Object Browser
Hi,
If your looking for MS Excel constants, properties, methods,etc..
Open your MS Excel-> Alt-F11 -> F2.
Object 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
Excel Sub Totals Collapse Group
Hi
Many thanks for the sample program. It has proved very useful.
Regards
Granville