Dim wn$, shp As Shape, arr
Application.ScreenUpdating = False
Application.DisplayAlerts = False
wn = [a1]
arr = Range(“o3:o” & Range(“o65536”).End(xlUp).Row)
Sheets(“报表”).Copy
With ActiveWorkbook
With .Sheets(1)
.Rows(“1:2”).Delete Shift:=xlUp
.Range(“D:D,P:P”).NumberFormatLocal = “@”
.[o1].Resize(UBound(arr)) = arr
With .UsedRange
.Value = .Value
End With
For Each shp In .Shapes
shp.Delete
Next
End With
.SaveAs ThisWorkbook.Path & “/” & wn & “.xls”, IIf(Application.Version <= 11, xlNormal, xlExcel8)
.Close
End With
Application.DisplayAlerts = True
Application.ScreenUpdating = True
MsgBox “ok”
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 86345@qq.com 举报，一经查实，本站将立刻删除。
