just a little help

there is about 5 threads here I am trying to reference regarding writing and overwriting a file. I understand the concept...

open file 1
open file 2
write line from file 1 to file 2
until it comes to the line that I wish to overwrite
....etc


I just can't put that to code, and I can't seem to modify the code I have seen on here to help me.
In my file, I have a string, separated by |'s on each line (1|hi|how|are|you). Each line starts with a number. The row I wish to replace is going to be the number from a counter (ie. if the counter is 4, I wish to replace row 4). I am replacing a string with a string (of the same length) (1|the|weather|is|nice) This string will not always be the same --the values of the replacement string are coming from textboxes.

I want it to have the ability to replace the i'th row (i being the counter)


any help? ideas? THANKS.

What are you doing this in? Excel? Word? Access?

Sorry.... doing the work in Word

And are these word documents or text files that you are dealing with?

Let me clarify (thanks for the help, btw)

using a userform within word, has 14 textboxes. User enters data, saves those text boxes into an array, and outputs to .txt file. The form has lets say 50 entries that they can scroll back through to view each entry's 14 textboxes.

Lets say, the user goes to the 37th entry, and wants to modify all 14 (doesn't have to be all 14) textboxes.

I'm looking to preserve all entries already entered, replacing the 37th entry with whatever its going to be typed in those boxes.

I can provide you with code if it would better help. thanks again.

probably the best way is to read the entire file into an array, you can then modify any element(s), and when finished write the array back out to the same (overwrite) text file or to a different text file

vb Code:

open "file1.txt" for input as 1  'supply path as required
    filearray = split(input(lof(1), #1), vbnewline)  'read whole file into array
close 1
 
  filearray(36) = newvalue  ' array is zero based so line 37 is element 36
  '  you can change as many elements of the array as you like before saving
  '  but you will need to declare the array in the general section at the top of the form or module
 
open "file1.txt" for output as 1 ' if you want new file supply new file name instead of overwriting
  print #1, join(filearray, vbnewline)  ' write array to file
close 1