Dim xlapp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Set xlapp = CreateObject("Excel.Application")
Set xlbook = xlapp.Workbooks.Open(App.Path & "\test.xlt") '打开已经存在的模板文件
xlapp.Visible = True
Set xlsheet = xlbook.Worksheets(1)
'下面就是简单的在一些单元格内写入数字
For i = 7 To 15
For j = 1 To 10
xlsheet.Cells(i, j) = j '当前工作簿第一页的第I行第J列
Next j
Next i
xlapp.ActiveWorkbook.SaveAs("d:\22.xls")
xlapp.Workbooks.close
xlapp.quit