需要引用Microsoft Visual Basic For Application Extensibility 5.3
2007还要勾选“信任对VBA工程对象模型的访问”(在安全设置对话框中)
Sub 复制模块()
模块 = "需要复制"
Set VbComp = ThisWorkbook.VBProject.VBComponents(模块)
S = VbComp.CodeModule.Lines(1, VbComp.CodeModule.CountOfLines)
Set NEWB = Workbooks.Add
NEWB.VBProject.VBComponents.Add(vbext_ct_StdModule).Name = 模块
NEWB.VBProject.VBComponents(模块).CodeModule.AddFromString S
End Sub 新建工作表并复制宏.rar(14.23 KB, 下载次数: 36)
需要引用Microsoft Visual Basic For Application Extensibility 5.3
2007还要勾选“信任对VBA工程对象模型的访问”(在安全设置对话框中)
Sub 复制模块()
模块 = "需要复制"
Set VbComp = ThisWorkbook.VBProject.VBComponents(模块)
S = VbComp.CodeModule.Lines(1, VbComp.CodeModule.CountOfLines)
Set NEWB = Workbooks.Add
NEWB.VBProject.VBComponents.Add(vbext_ct_StdModule).Name = 模块
NEWB.VBProject.VBComponents(模块).CodeModule.AddFromString S
End Sub 新建工作表并复制宏.rar(14.23 KB, 下载次数: 36)