How to do Selection.Subtotal in VBScript/ASP ?
Anyone with experience in these matters? I am trying to group an Excel
sheet from VBScript.
No trouble doing it from a macro...
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5, 6,
7, 8), Replace:=False, PageBreaks:=False, SummaryBelowData:=True
but I can't get it to work in VBS. Specifically, this does not work,
even though it should - intrinsic constant xlSum is replaced with its
value...
objXL.Selection.Subtotal 1, -4167, Array(5, 6, 7, 8), False, False,
True
Web search shows that others have had the same problem, but no solution
given. References to an April, 2005 article in Windows Scripting
Solutions, but I don't have that.
Thanks for any assistance!
|