You will need to open the file with Random access for Read Write; e.g.
Open "C:\Myfile.txt" for Random Read Write as #1
It needs to be random access so you can read in data, then "skip back" to
re-write that data back to the file. Then use Input# or Get to read the data
from the file; read it in, edit it, and write it back with Write# or Print#
or Put. For details see VBA help files on all these functions and also the
topic "Writing Data to Files."
--
- K Dales


"DHallam" wrote:


Hi Guy's

I am trying to create a small data with customer info from an excel
worksheet. I am currently able to export the information into a text
file and understand that by using the code "output" it will create a
new file or alternatively using the code "append" and it will add the
info to the end of the file.

However....

Can anyone help me with amending the data once in the text file i think
it is the replace function but have no idea of the code.

Any help would be fantastic

Thanks
Dave


--
DHallam
------------------------------------------------------------------------
DHallam's Profile: http://www.excelforum.com/member.php...o&userid=25253
View this thread: http://www.excelforum.com/showthread...hreadid=387948