Write data to an existing textfile

[Joakim N]

I want to:
1. Open an existing textfile
2. Find a certain string
3. Increase the number at string by one (+1)
4. Store and close textfile

Example:
Find string B and increase number by one

Before
A: 1
B: 2
C: 5

After
A: 1
B: 3
C: 5

[patel45]

can you attach a real text file ?

[HaHoBe]

Hi, Joakim N,

assuming that the string to search is in cell B2 on the active sheet you should alter Path, Folder and name of the text file to suit:

Please Login or Register  to view this content.

Ciao,
Holger

[Joakim N]

Thanks,
I thought it was possible to write directly in a textfile with content already. Now it solved by reading data from a stored textfile, make the changes, write data to a new textfile and write over the old stored textfile.

Please Login or Register  to view this content.