WPS平台上VBA粘贴代码运行出错

公司现在从Excel切换到wps,以下的代码是去公式的VBA代码,之前在excel2016上是正常运行的,现在到了wps平台后,当第二次运行到“ .UsedRange.PasteSpecial xlValues”系统报错,报错提示为:运行时错误'-1880945651(8fe30c0d)':自动化(Automation)错误,不知道是什么原因,该如何解决。请各位老师指点赐教。

Sub arpt()

ThisWorkbook.Save

With Application

.Calculation = xlCalculationManual

.DisplayAlerts = False

End With

Dim i As Integer, v As Variant, b As Boolean, i2 As Integer, pa As Variant

Application.Calculate

pa = Range(Sheets("ds").Cells(1, 1).End(xlToRight), Sheets("ds").Cells(15, 2))

v = Split(pa(13, 1), ";")

Sheets(Split(pa(12, 1), ";")).Delete

Sheets("mail").Visible = xlSheetHidden

For i = 1 To Sheets.Count

With Sheets(i)

For i2 = 0 To UBound(v)

If .Name = v(i2) Then

b = True

Exit For

End If

Next i2

If Not b Then

.UsedRange.Copy

.UsedRange.PasteSpecial xlValues

End If

b = False

End With

Next i

Worksheets(pa(14, 1)).Select

SaveAs Path & pa(15, 1)

t = DateAdd("s", 5, Now) '延时2秒

Do Until Now > t

DoEvents

Loop

End Sub

浙江省
浏览 1290
收藏
点赞
分享
+1
1
+1
全部评论 1
 
熊WPS
光看代码不好确定,传个附件能给整下。
· 安徽省
回复