How to run subtotal function from ASP?
Still can't find anything on this. Thought I'd try to
post again. I need to run the subtotal function for an
excel sheet from an asp page.
I can't find the syntax anywhere for this. The closest I
can get after recording a macro and stripping out the
xlconstants is this.
..Selection.Subtotal 5, -4157, Array(10, 12, 13, 16, 18,
21, 24, 27), True, False, True
However, the page just hangs on this line when called.
Desperatly need some help!
Thanks!
|