update txt file

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

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
 
what about opening the old version in Excel, making your changes, and then
saving it again as the text file?

Sarah
 
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
 
Back
Top