View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Smith Don Smith is offline
external usenet poster
 
Posts: 2
Default 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!