Private Sub Form_Click()
Me.AutoRedraw = True
Dim xlsApp As Excel.Application
Dim xlsworkbook As Excel.Workbook
Dim xlssheet As Excel.Worksheet
Set xlsApp = CreateObject("Excel.Application")
Set xlsworkbook = xlsApp.Workbooks.Open("D:\mdb\Book1.xls", , , ,
"123456" )
xlsApp.Visible = True
Set xlssheet = xlsworkbook.Worksheets.Item(1)
Dim Mat(1 To 10, 1 To 4) As String
Dim i As Integer, j As Integer
For i = 1 To 10
For j = 1 To 4
Mat(i, j) = xlssheet.Cells(i, j)
Next
Next
For i = 1 To 10
For j = 1 To 4
Print Mat(i, j);
Next
Print
Next
Set xlssheet = Nothing
Set xlsworkbook = Nothing
Set xlsApp = Nothing
End Sub