vb从网页下载xlsx文件后,Set xlbook = xlapp.Workbooks.Open(s)打开时报错,手动打开xlsx发现文件是需要修复的,
修复保存后再执行同段代码就能顺利打开,请问各位大神,如何用vb代码规避这个问题,怎样才能直接打开这种需要修复的xlsx文件。
已尝试以下方法无效,
Application.DisplayAlerts = True/false
以下是代码
Private Sub Command16_Click()
Call jianCha_s("D:\Users\dell\Desktop\按需审计\附件\2-180625-005-00962.xlsx")
End Sub
Private Function jianCha_s(s As String)
Dim i As Integer, x As Integer, y As Integer, j As Integer, k As Integer, z As Integer, zz As Integer
Dim ireco As Integer, strsql As String
Dim sy() As String
If Reco.State <> adStateClosed Then
Reco.Close
Set Reco = Nothing
End If
strsql = "select * from illegal_s"
Reco.Open (strsql), Conn, 3, 3
ireco = Reco.RecordCount
Reco.MoveFirst
ReDim sy(ireco - 1)
For x = 0 To ireco - 1
sy(x) = Reco.Fields(1)
Reco.MoveNext
Next
Reco.Close
Set Reco = Nothing
Application.DisplayAlerts = True
Set xlapp = CreateObject("excel.application")
xlapp.Visible = True
Set xlbook = xlapp.Workbooks.Open(s)
i = xlapp.Worksheets.Count
*******
*******
*******
*******
*******
xlbook.Close
xlapp.Quit
Set xlbook = Nothing
Set xlapp = Nothing
Application.DisplayAlerts = True
End Function