下面的程序,执行到msgbox 一句时报错“应用程序定义错误或对象定义报错”,是什么问题?Set xlBook = Exl.Workbooks.Open("C:\1.xls")
Set xlSheet = xlBook.ActiveSheet
For IRow = 0 To xlSheet.UsedRange.Rows.Count
For ICol = 0 To xlSheet.UsedRange.Columns.Count
MsgBox xlSheet.Cells(IRow, ICol)
Next
Next
Set xlSheet = xlBook.ActiveSheet
For IRow = 0 To xlSheet.UsedRange.Rows.Count
For ICol = 0 To xlSheet.UsedRange.Columns.Count
MsgBox xlSheet.Cells(IRow, ICol)
Next
Next
改成
set xlbook=getobject("c:\1.xls")
For ICol = 1 To xlSheet.UsedRange.Columns.Count