Dim xlsApp As Excel.Application
Dim xlsBook As Excel.Workbook
Dim xlsSheet As Excel.Worksheet
Set xlsApp = New Excel.Application
Set xlsBook = xlsApp.Workbooks.Add
Set xlsSheet = xlsBook.Worksheets(1)
查詢數據
While Not AdoRst.EOF
xlsSheet.Cells(i, 1) = AdoRst(0)
......
i = i + 1
AdoRst.MoveNext
Wend
If Dir("c:\sale_chk.xls") <> "" Then Kill "c:\sale_chk.xls"
xlsBook.SaveAs "c:\sale_chk.xls"