'问题补充看到了,下面是修改后的代码。
Private Sub Command1_Click()
Dim S() As String, i As Integer, j As Integer
Dim Rows1() As String, Rows2() As String
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
'以下读入1.xls中的Sheet1内的E列数据到数组Rows1()
Set xlBook = xlApp.Workbooks.Open("c:\1.xls") '把它改成具体文件名称
Set xlSheet = xlBook.Worksheets("Sheet1")
ReDim Rows1(1 To 200) '最大列数自己定义
For i = 1 To UBound(Rows1)
Rows1(i) = xlSheet.Cells(i, 5)
Next
xlBook.Close (True)
xlApp.Quit
'以下读入2.xls中的Sheet1内的F列数据到数组Rows2()
Set xlBook = xlApp.Workbooks.Open("c:\2.xls") '把它改成具体文件名称
Set xlSheet = xlBook.Worksheets("Sheet1")
ReDim Rows2(1 To 200) '最大列数自己定义
For i = 1 To UBound(Rows2)
Rows2(i) = xlSheet.Cells(i, 6)
Next
xlBook.Close (True)
xlApp.Quit
Set xlBook = Nothing
Set xlBook = Nothing
Set xlApp = Nothing '释放xlApp对象
MsgBox "已经把2个Excel文件有关的值赋给了数组!", vbInformation, "提示"
Unload Me
End Sub
温馨提示:答案为网友推荐,仅供参考