Close text file after editing in excel VBA macro

See more:

MS-Excel

macros

Hi All,

I have this text file which I need to edit.
Edit has to be done one line at a time.
I was wondering how to save and close the text file after editing!!

Thanks...

What I have tried:

Public Sub edit_sub()

Dim myFile As String
Dim opFile As Integer
myFile = "fileLocation"

opFile = FreeFile
Open myFile For Input As opFile


Do Until EOF(opFile)
    Line Input #opFile, txtline
    Debug.Print txtline
    
    'check some condition and then edit
    'replace the value
Loop

Close opFile

End Sub

Where to put the code to save the text file?