update txt file

[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

 

[Sarah B via OfficeKB.com]

what about opening the old version in Excel, making your changes, and then
saving it again as the text file?

Sarah

 

[Harald Staff]

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