VB中将数据输出到Excel模版打印出现错误

来源:百度知道 编辑:UC知道 时间:2024/06/15 02:09:39
老是说实时错误'3265':在所对应所需的名称或序数的集合中未找到项目
点击调试后说这句有问题:
exlapp.Sheets(1).Cells(i, j + 1) = Adodc1.Recordset(j + 2)

下面是代码:
Option Explicit
Dim exlapp As New Excel.Application '定义Excel对象
Dim exlbook As Excel.Workbook '定义Excel工作簿对象
Dim exlsheet As Excel.Worksheet '定义Excel工作表对象
Private Sub Command1_Click()
Dim i As Integer, j As Integer
If Adodc1.Recordset.RecordCount > 0 Then
Set exlapp = New Excel.Application
exlapp.Workbooks.Open App.Path & "\职工表1.xlt"
Adodc1.Recordset.MoveFirst
exlapp.Sheets(1).Cells(2, 2) = Adodc1.Recordset(3)
Adodc1.Recordset.MoveFirst
i = 4
Do While Adodc1.Recordset.EOF = False
For j = 0 To 8
If IsNull(DataGrid1.Text) = False Then
exlapp.Sheets(1).Cells(i, j + 1) = Adodc1.Record

exlapp.Sheets(1).Cells(i, j + 1) = Adodc1.Recordset(j + 2)?
好像sheet不能直接通过application引用,要通过workbook对象,可以换成
xlbook.Sheets(1).Cells(i, j + 1) = Adodc1.Recordset(j + 2)或
exlapp.activeworkbook.Sheets(1).Cells(i, j + 1) = Adodc1.Recordset(j + 2)之类的试试.