Public Sub readExcel()Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.WorksheetSet xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("C:\Documents and Settings\Administrator\1.xls")Set xlsheet = xlBook.Worksheets(1)MsgBox ("hehe")
Dim m As Integer 'row
Dim n As Integer 'column
For m = 7 To 10
For n = 1 To 8
MsgBox xlsheet.Cells(m, n)
Next
Next
End Sub
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.WorksheetSet xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("C:\Documents and Settings\Administrator\1.xls")Set xlsheet = xlBook.Worksheets(1)MsgBox ("hehe")
Dim m As Integer 'row
Dim n As Integer 'column
For m = 7 To 10
For n = 1 To 8
MsgBox xlsheet.Cells(m, n)
Next
Next
End Sub
xlsheet.Active
总是报错!如果我sheet1的名字是别的,应该要改吧?
xlBook.Close False
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing我是搂住!
总是报错!如果我sheet1的名字是别的,
应该要改!!!
你自己不是说报错了吗?把你看到的文字贴上来
这样可以运行了。