Sub test() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count With .VBProject.VBComponents(i).CodeModule .DeleteLines 1, .CountOfLines End With Next End With End Sub
Sub test() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count With .VBProject.VBComponents(i).CodeModule .DeleteLines 1, .CountOfLines End With Next End With End Sub
以下是引用Zipall在2010-10-29 20:54:00的发言: Sub test() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count With .VBProject.VBComponents(i).CodeModule .DeleteLines 1, .CountOfLines End With Next End With End Sub
借用2楼的代码 Sub test() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count If .VBProject.VBComponents(i).CodeModule <> "删除模块" Then With .VBProject.VBComponents(i).CodeModule .DeleteLines 1, .CountOfLines EndWith EndIf Next EndWith EndSub
Sub TEST() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count With .VBProject.VBComponents(i) If .Name <> "AAA" Then .CodeModule.DeleteLines 1, .CodeModule.CountOfLines End With Next End With End Sub
以下是引用那么的帅在2010-10-29 21:07:00的发言: 借用2楼的代码 Sub test() With ThisWorkbook For i = 1 To .VBProject.VBComponents.Count If .VBProject.VBComponents(i).CodeModule <> "删除模块" Then With .VBProject.VBComponents(i).CodeModule .DeleteLines 1, .CountOfLines End With End If Next End With End Sub