Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlWorksheet As Excel.Worksheet
Dim xlActiveSheet As Excel.WorksheetSet xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open("C:\123.xls"))
Set xlWorksheet = xlBook.Worksheets("sheet1")
Set xlActiveSheet = xlApp.ActiveSheet
lblTotal.Caption = xlActiveSheet.UsedRange.Rows.count - 1
xlBook.Close
Set xlBook = Nothing
Set xlApp = Nothing
Set xlWorksheet = Nothing
Set xlActiveSheet = Nothing
Dim xlBook As Excel.Workbook
Dim xlWorksheet As Excel.Worksheet
Dim xlActiveSheet As Excel.WorksheetSet xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open("C:\123.xls"))
Set xlWorksheet = xlBook.Worksheets("sheet1")
Set xlActiveSheet = xlApp.ActiveSheet
lblTotal.Caption = xlActiveSheet.UsedRange.Rows.count - 1
xlBook.Close
Set xlBook = Nothing
Set xlApp = Nothing
Set xlWorksheet = Nothing
Set xlActiveSheet = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货