Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
How do I output to the same position in a Text file everytime? I want to output 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? I use the following command: Write #10, dateline, variable1, variable2, variable3 'where dateline is today's date in excel date code. I drop into the file at the row corresponding to last week's date e.g. row 40010. 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 40017. 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel crashes everytime I send focus from control to worksheet | Excel Programming | |||
Send worksheet to text file | Excel Programming | |||
Possible to write VBA code to send out an EMAIL everytime a workbook is opened? | Excel Programming | |||
send contents of cell b4 to a plain text file | Excel Programming | |||
How do I send some cells to an external text file? | Excel Programming |