ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to run subtotal function from ASP? (https://www.excelbanter.com/excel-programming/284996-how-run-subtotal-function-asp.html)

Wes[_5_]

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!


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com