Dim xlApp As Excel.Application
Set xlApp = New Excel.Application Set xlApp = CreateObject("Excel.Application")
'激活EXCEL应用程序
xlApp.Visible = False '隐藏EXCEL应用程序窗口
Set xlBook = xlApp.Workbooks.Open(strDestination)
'打开工作簿,strDestination为一个EXCEL报表文件
Set xlSheet = xlBook.Worksheets(1)
'设定工作表 strXXXX=xlSheet.Cells(1,1)
Set xlApp = New Excel.Application Set xlApp = CreateObject("Excel.Application")
'激活EXCEL应用程序
xlApp.Visible = False '隐藏EXCEL应用程序窗口
Set xlBook = xlApp.Workbooks.Open(strDestination)
'打开工作簿,strDestination为一个EXCEL报表文件
Set xlSheet = xlBook.Worksheets(1)
'设定工作表 strXXXX=xlSheet.Cells(1,1)
盼回复,救急
for i=1 to 10
a(i)=xlSheet.Cells(i,1)
next