这样不好,如果不是安装在C盘,或版本不一样就不行了,还是用EXCEL对象吧 set xlApp=createobject("Excel.Application") xlApp.workbooks.open filename:="d:\ddd.xls",password:="xxxxxx" xlApp.visible=true
Private Sub Command1_Click() Dim i As Integer Set xlApp = CreateObject("Excel.Application") On Error GoTo 10: '出错处理 For i = 0 To 9 xlApp.workbooks.Open FileName:="d:\ddd.xls", Password:=i '当i>1时出错处理的语句就不管用了,请问为什么呢? xlApp.Visible = True End 10: Err = 0 '出错处理 Next i End Sub当i>1时出错处理的语句就不管用了,请问为什么呢?
Private Sub Command1_Click() Dim i As Integer Set xlApp = CreateObject("Excel.Application") On Error GoTo 10: '出错处理 For i = 0 To 9 xlApp.workbooks.Open FileName:="d:\ddd.xls", Password:=i '当i>1时出错处理的语句就不管用了,请问为什么呢? xlApp.Visible = True End exit sub 10: if Err.number <> 0 '出错处理 debug.print "出错!!!!" end if Next i End Sub
set xlApp=createobject("Excel.Application")
xlApp.workbooks.open filename:="d:\ddd.xls",password:="xxxxxx"
xlApp.visible=true
Dim i As Integer
Set xlApp = CreateObject("Excel.Application")
On Error GoTo 10: '出错处理
For i = 0 To 9
xlApp.workbooks.Open FileName:="d:\ddd.xls", Password:=i '当i>1时出错处理的语句就不管用了,请问为什么呢?
xlApp.Visible = True
End
10:
Err = 0 '出错处理
Next i
End Sub当i>1时出错处理的语句就不管用了,请问为什么呢?
Dim i As Integer
Set xlApp = CreateObject("Excel.Application")
On Error GoTo 10: '出错处理
For i = 0 To 9
xlApp.workbooks.Open FileName:="d:\ddd.xls", Password:=i '当i>1时出错处理的语句就不管用了,请问为什么呢?
xlApp.Visible = True
End
exit sub
10:
if Err.number <> 0 '出错处理
debug.print "出错!!!!"
end if
Next i
End Sub