Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Amending a formula | Excel Discussion (Misc queries) | |||
Amending another formula | Excel Discussion (Misc queries) | |||
Saving an excel file without it amending the name of file name | Excel Discussion (Misc queries) | |||
Help amending code | Excel Discussion (Misc queries) | |||
Help with Amending this Code Please | Excel Worksheet Functions |