Hi Andy

Append, like this:

Sub test()
Dim iFnum As Integer
iFnum = FreeFile
Open "C:\temp\text.txt" For Append As #iFnum
Print #iFnum, Now
Close #iFnum
End Sub

HTH. Best wishes Harald

"andy" skrev i melding
...
hi hope someone can help
i can write values from excel to a txt file
but it overwrites the exsisting value in the txt file
can someone please tell me how you can just update the txt file with the
new values



Andy