LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default How to do selection.subtotal in VBScript/ASP ?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUBTOTAL - dynamic selection Totteridge Ram Excel Worksheet Functions 3 December 17th 08 01:09 AM
Run VBScript from Excel Amy M Excel Discussion (Misc queries) 4 September 19th 08 09:07 PM
Anoth vbscript question ... sorry ! Sean Setting up and Configuration of Excel 1 March 20th 08 09:22 PM
Subtotal line selection Jenny Excel Discussion (Misc queries) 1 April 13th 05 02:21 PM
How to move worksheet from vbscript Robert Stober Excel Programming 1 October 9th 03 10:19 AM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"