Sub エ栋17()
'
' エ栋17 エ栋
'
'
Application.DisplayAlerts = False
Dim i As Integer
i = Range("e65535").End(xlUp).Row
Range("a1") = i
Range("A1:E" & i).Select
Selection.Copy
Sheets.Add After:=ActiveSheet
ActiveSheet.Paste
Sheets(2).Select
Application.CutCopyMode = False
Sheets(2).Move
ActiveWorkbook.SaveAs Filename:="D:\code\03_liaohao\茂170.xls", FileFormat _
:=xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
ActiveWindow.Close
Application.DisplayAlerts = True
End Sub
excel筛选后内容 另存xls 如果有文件 覆盖并且不提示
最新推荐文章于 2021-07-08 16:52:18 发布