Vba把Excel某个范围保存为XLS工作薄文件

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 = https://www.taobao49.com/265030/.Value
End With
For Each shp In .Shapes
shp.Delete
Next
【Vba把Excel某个范围保存为XLS工作薄文件】End With
.SaveAs ThisWorkbook.Path & “” & wn & “.xls”, IIf(Application.Version <= 11, xlNormal, xlExcel8)
.Close
End With
Application.DisplayAlerts = True
Application.ScreenUpdating = True
MsgBox “ok”

Vba把Excel某个范围保存为XLS工作薄文件

推荐阅读

关于节约粮食的名言诗句关于节约粮食的名言和诗句

奋斗励志朋友圈句子励志短句致自己奋斗朋友圈

想发朋友圈表示心情不好的句子心情不好发朋友圈的句子心情短句

贝拉玻尿酸是合法的吗贝拉玻尿酸是进口的还是国产的

核桃仁做菜的菜谱，您知道桃仁脆溜鸡的做法

浅紫色显皮肤黑还是白

库伦旗景点

居家隔离和集中隔离的区别什么情况下要隔离28天

蝉蛹是什么

怎样能丰胸最安全有效