Dim myVBComponent
Dim iCodeLines As Integer
For Each myVBComponent In ThisWorkbook.VBProject.VBComponents
If myVBComponent.CodeModule.Name = "Module2" Then
myVBComponent.CodeModule.AddFromString ("Public Const aaa as string=""" + Sheets(1).Cells(1, 1).Text + """")
End If
Next
End Sub
Sub deleteMacro()
On Error Resume Next
Dim myVBComponent
Dim iCodeLines As Integer
// 对当前工作簿中的VBComponents集合进行遍历
For Each myVBComponent In ThisWorkbook.VBProject.VBComponents
If myVBComponent.CodeModule.Name = "Module2" Then
// 删除模块Module2中的所有代码
iCodeLines = myVBComponent.CodeModule.CountOfLines
myVBComponent.CodeModule.DeleteLines 1, iCodeLines
End If
Next
End Sub