B
Bharathi mohan
Hi friends,
I wrote a macro such that it will append some data at the end of th
excel file(I opened the file in binary mode and wrote the content)
The sample code will be like this
Open filename For Binary Access Write As #1
If startpos = 0 Then
startpos = LOF(1)
End If
Put #1, startpos, "my data"
Close #1
After closing the file and opening it in Notepad the data is stil
there.
But if i reopened it in excel and closed the file, the data is gone.
Excel overwrites the user defined data.
Assist me in keeping my data persistent so that i will retrieve th
contents and process it
I wrote a macro such that it will append some data at the end of th
excel file(I opened the file in binary mode and wrote the content)
The sample code will be like this
Open filename For Binary Access Write As #1
If startpos = 0 Then
startpos = LOF(1)
End If
Put #1, startpos, "my data"
Close #1
After closing the file and opening it in Notepad the data is stil
there.
But if i reopened it in excel and closed the file, the data is gone.
Excel overwrites the user defined data.
Assist me in keeping my data persistent so that i will retrieve th
contents and process it