1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Dim i As Integer
Dim nf As Integer
Dim modnum As Integer
Dim codeline As String
For i = 1 To Application.VBE.ActiveVBProject.VBComponents.Count
If Application.VBE.ActiveVBProject.VBComponents(i).Name = "mod1" Then
modnum = i
End If
Next i
Application.VBE.ActiveVBProject.VBComponents(modnum).CodeModule.DeleteLines 1, Application.VBE.ActiveVBProject.VBComponents(modnum).CodeModule.CountOfLines
nf = FreeFile
Open ThisWorkbook.Path & "\test.txt" For Input As #nf
Do While Not EOF(nf)
Input #nf, codeline
Application.VBE.ActiveVBProject.VBComponents(modnum).CodeModule.InsertLines Application.VBE.ActiveVBProject.VBComponents(modnum).CodeModule.CountOfLines + 1, codeline
Loop
Close nf |