請教:有關EXCEL的問題
請教:
,EXCEL里的宏代码如下:
Selection.Subtotal(GroupBy:=4, Function:=xlSum, TotalList:=Array(5, 6, 7, 8, _
9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 _
, 36, 37, 38), Replace:=True, PageBreaks:=False, SummaryBelowData:=True)
我要弄到vb.net里該怎麼樣用呀??
我這樣寫提示出錯啦
Dim Myexcel As Excel.Application = New Excel.Application
Dim MyBook As Excel.Workbook
Dim Mysheet As Excel.Worksheet
MyBook = Myexcel.Workbooks.Open(Application.StartupPath & "\TEMP.xls")
Mysheet = MyBook.Worksheets(1)
Myexcel.Visible = False
Mysheet.Activate()
Myexcel.Selection.Subtotal(GroupBy:=4, Excel.XlConsolidationFunction.xlsum, TotalList:=Array(5, 6, 7, 8, _
9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 _
, 36, 37, 38), Replace:=True, PageBreaks:=False, SummaryBelowData:=True)
出錯提示為:Excel.XlConsolidationFunction.xlsum這里的EXCEL需要命名參數,
TotalList:=Array(....)這里的Array是一個類型,不能用作表達式
該怎麼樣寫呢???