我在VB里导出EXCEL时,出现如下错误:对象‘CopyFromRecordset’的方法‘Range’失败我的代码如下: Dim myexcel As New Excel.Application
Dim mybook As New Excel.Workbook
Dim mysheet As New Excel.Worksheet
Set mybook = myexcel.Workbooks.Add '添加一个新的BOOK
Set mysheet = mybook.Worksheets.Add '添加一个新的SHEET
myexcel.Visible = True rst.Open strsql, S_cn, adOpenKeyset, adLockReadOnly
mysheet.Cells.CopyFromRecordset rst mybook.SaveAs cd.FileName '保存文件 rst.Close
Set rst = Nothing
请那位仁兄帮我看看 ?
Dim mybook As New Excel.Workbook
Dim mysheet As New Excel.Worksheet
Set mybook = myexcel.Workbooks.Add '添加一个新的BOOK
Set mysheet = mybook.Worksheets.Add '添加一个新的SHEET
myexcel.Visible = True rst.Open strsql, S_cn, adOpenKeyset, adLockReadOnly
mysheet.Cells.CopyFromRecordset rst mybook.SaveAs cd.FileName '保存文件 rst.Close
Set rst = Nothing
请那位仁兄帮我看看 ?
--什么意思?我这段程序以前都能执行,现在不行了,着急啊!!!
EXCEL 2000 以上才支持 ADO。