[AccessD] Excel Subtotal from Access/VBA

Mark Simms marksimms at verizon.net
Sat Oct 29 09:14:19 CDT 2011


Just reference the entire worksheet (change activesheet below to
worksheets("whatever") if required).
My notes on this function indicate to put a Application.DisplayAlerts=False
statement in there too.

>
>     With ApXL
>
>         .ActiveSheet.Subtotal GroupBy:=4, Function:=xlSum,
> TotalList:=Array(12), _
>
>             Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
>         .ActiveSheet.Outline.ShowLevels RowLevels:=2
>
>         .Columns("L:L").Style = "Currency"
>
>         .Rows("1:1").Font.Bold = True
>





More information about the AccessD mailing list