Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to run subtotals on an excel sheet from an ASP
page. I'm able to create the page and populate it with data, but I can not figure out how to subtotal. When I created a macro, the VB line was the following: Selection.Subtotal GroupBy:=5, Function:=xlSum, TotalList:=Array(10, 12, 13 _ ), Replace:=True, PageBreaks:=False, SummaryBelowData:=True This line creates an error in the ASP page, and I read that I should remove the names and := suymbols. This gave me the following line: ..Selection.Subtotal 5, xlSum, Array(10, 12, 13, 16, 18, 21, 24, 27), True, False, True This line does not create an error, but it doesn't subtotal either, it just cuases the browser to hang. I read how to do this in Fox Pro, so I assume their is a way to handle it in VB Script. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUBTOTAL - dynamic selection | Excel Worksheet Functions | |||
Run VBScript from Excel | Excel Discussion (Misc queries) | |||
Anoth vbscript question ... sorry ! | Setting up and Configuration of Excel | |||
Subtotal line selection | Excel Discussion (Misc queries) | |||
How to move worksheet from vbscript | Excel Programming |