批量删除多个相同格式内容的Excel表格的列
Sub Del_Col()
Application.DisplayAlerts = False
Dim myFiles As String
Dim myExcels As String
With Application.FileDialog(msoFileDialogFolderPicker)
.Show
.AllowMultiSelect = False
.Title = “请选择要删除列的文件所在文件夹”
myFiles = .SelectedItems(1)
End With
myExcels = Dir(myFiles & “\” & “*.xls*”)
Do While Len(myExcels) <> 0
Workbooks.Open (myFiles & “\” & myExcels)
Worksheets(1).Columns(“H:H”).Delete
Worksheets(1).Columns(“F:F”).Delete
Worksheets(1).Columns(“E:E”).Delete
Worksheets(1).Columns(“C:C”).Delete
Worksheets(1).Columns(“B:B”).Delete
ActiveWorkbook.Save
Workbooks(2).Close
myExcels = Dir
Loop
Application.DisplayAlerts = True
MsgBox “删除完成”
End Sub
版权声明：本文为zhaco原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。