Excel automation with VB.NET


  • Hello,

    I have done some Excel-to-VB.NET automation, so I am familiar with the basics.  I have gotten stuck on doing Subtotals.

    The VBA macro looks like this::

    .Selection.Subtotal(GroupBy:=2, Function:=xlSum, TotalList:=Array(5), Replace:=False, PageBreaks:=False, SummaryBelowData:=True)

    I cannot figure out how to reference the  "Array(5)" object in VB.NET.  Any ideas?

    Thanks for any suggestions.
    Mister T

    Friday, June 17, 2005 7:43 PM

All replies


    (Using VB 2005 Express Edition)

    I'm having the same trouble. Also, I can't get the "sawtooth" out from under the Selection.Subtotal.

    I'd appreciate  some help too!


    Tuesday, January 03, 2006 12:06 AM