Amending a text file
 

Hi Guy's

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

However....

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

Any help would be fantastic

Thanks
Dav

--
DHalla
-----------------------------------------------------------------------
DHallam's Profile: http://www.excelforum.com/member.php...fo&userid=2525
View this thread: http://www.excelforum.com/showthread.php?threadid=38794

Amending a text file
 

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

Amending a text file
 

Thanks for your previous reply, unfortunately I am still not able to
solve it however I have now posted a more accurate description of what
it is I believe I require.

Kind Regards
Dave


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