Miscellany

Private Sub Command1_Click()
    Dim nFileNum1 As Integer
    Dim nFileNum2 As Integer
    Dim sText As String, sNextLine As String, lLineCount As Long
    
    'MsgBox Adodc1.ConnectionString
    Open "C:\stkcde2.txt" For Input As nFileNum1
    Open "C:\stkcde3.txt" For Output As nFileNum2
    Do While Not EOF(nFileNum1)
       Line Input #nFileNum1, sNextLine
       'do something with it
       'add line numbers to it, in this case!
       sNextLine = sNextLine & vbCrLf
       sText = sText & sNextLine
       Print #nFileNum2, sText
    Loop
    Text1.Text = sText
     
    ' Close the file
    Close nFileNum2
    Close nFileNum1
End Sub