Sub duplet() СОЗДАТЬ_ОГЛАВЛЕНИЕ :СОЗДАТЬ_ОГЛАВЛЕНИЕEnd Sub
Sub duplet() СОЗДАТЬ_ОГЛАВЛЕНИЕ Application.OnTime Now + TimeValue("00:00:01"), "СОЗДАТЬ_ОГЛАВЛЕНИЕ"End Sub
Dim lCntDeclrLines As Long sCodeName = ActiveSheet.CodeName sCode = sProc1 & vbLf & vbLf & sProc2 Set oSh = ActiveWorkbook.VBProject.VBComponents(sCodeName) lCntDeclrLines = oSh.CodeModule.CountOfDeclarationLines + 1 oSh.CodeModule.InsertLines lCntDeclrLines, sCode
Set oSh = ActiveWorkbook.VBProject.VBComponents(sCodeName) Debug.Print "CountOfLines = " & oSh.CodeModule.CountOfLines lCountOfLines = oSh.CodeModule.CountOfLines oSh.CodeModule.DeleteLines 1, lCountOfLines Debug.Print "CountOfLines = " & oSh.CodeModule.CountOfLines
oSh.CodeModule.InsertLines 1, sCode
Dim objVBPrj as object, oSh as objectDim lCntDeclrLines As LongsCodeName = ActiveSheet.CodeNamesCode = sProc1 & vbLf & vbLf & sProc2Set objVBPrj = ActiveWorkbook.VBProjectSet oSh = objVBPrj.VBComponents(sCodeName)lCntDeclrLines = oSh.CodeModule.CountOfDeclarationLines + 1oSh.CodeModule.InsertLines lCntDeclrLines, sCode
Dim VBProj As VBIDE.VBProject Dim VBComp As VBIDE.VBComponent Dim CodeMod As VBIDE.CodeModule Dim sCodeName$, lFirstProcLine& sCodeName = ActiveSheet.CodeName Set VBProj = Application.ActiveWorkbook.VBProject Set VBComp = VBProj.VBComponents(sCodeName) Set CodeMod = VBComp.CodeModule lFirstProcLine = CodeMod.CountOfDeclarationLines + 1 CodeMod.InsertLines lFirstProcLine, sCode