Output to a fixed row in a Text file
 

hi there
How do I output to the same position in a Text file everytime? I want to
dump data for a given Date so I'd like to put it in the same row for that
Date everytime, and so overwrite the existing data in that row?
thank you
Bernard.

Output to a fixed row in a Text file
 

I think you are going to have to tell us the structure of that text file
(how it is laid out) before we can begin to guess at what needs to be done.

--
Rick (MVP - Excel)


"Bernard" wrote in message
...
hi there
How do I output to the same position in a Text file everytime? I want to
dump data for a given Date so I'd like to put it in the same row for that
Date everytime, and so overwrite the existing data in that row?
thank you
Bernard.

Output to a fixed row in a Text file
 

Rick
I use the following command:
Write #10, dateline, variable1, variable2, variable3
'where dateline is today's date in excel date code.
Write #10, dateline+1, variable1, variable2, variable3
'where dateline +1 is tomorrow's date in excel date code.


I drop into the file at the row corresponding to today's date e.g. row 40010.
I want to be able to open my text file, overwrite the existing data in that
file for the row corresponding to today's date. Is it possible to write to a
specific row in a text file.....
thanking you
Bernard



"Rick Rothstein" wrote:

I think you are going to have to tell us the structure of that text file
(how it is laid out) before we can begin to guess at what needs to be done.

--
Rick (MVP - Excel)


"Bernard" wrote in message
...
hi there
How do I output to the same position in a Text file everytime? I want to
dump data for a given Date so I'd like to put it in the same row for that
Date everytime, and so overwrite the existing data in that row?
thank you
Bernard.




.