GettingThere
New Member
- Joined
- Mar 10, 2009
- Messages
- 19
Hi guys,
I have an Excel userform that takes user data and writes it to a txt file. Certain function it has also reads the data by the user specifying a line number and the macro reading until it gets to that line and then displaying it as required.
However once it has reached the specific line is there any way I can:
1. Read the line in to a string
2. Find and replace what I need to
-----I can do the above two points---
3. Delete the original line, and
4. Write the new string back in it's place? - So not at the end but at the same line number as the original source.
Any suggestions would be much appreciated!! =D
Thanks,
A.
I have an Excel userform that takes user data and writes it to a txt file. Certain function it has also reads the data by the user specifying a line number and the macro reading until it gets to that line and then displaying it as required.
However once it has reached the specific line is there any way I can:
1. Read the line in to a string
2. Find and replace what I need to
-----I can do the above two points---
3. Delete the original line, and
4. Write the new string back in it's place? - So not at the end but at the same line number as the original source.
Any suggestions would be much appreciated!! =D
Thanks,
A.