手机
当前位置:查字典教程网 >电脑 >Excel教程 >Vba把Excel某个范围保存为XLS工作薄文件
Vba把Excel某个范围保存为XLS工作薄文件
摘要:Dimwn$,shpAsShape,arrApplication.ScreenUpdating=FalseApplication.Displ...

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"

【Vba把Excel某个范围保存为XLS工作薄文件】相关文章:

VBA把记事本保存成为工作薄

如何为Excel工作表设置表格定义

Excel怎么制作柱状折线图

彻底隐藏Excel2007文档工作表

excel中怎么调出窗体工具栏

excel保存时怎么自动备份

excel怎么保护单元格

Excel表格如何转换为Word文档

Excel中排出并列的名次

Excel表格只能看不能改的区域加密方法

精品推荐
分类导航