Reading/Writing Data to a Text File using VBA

[Anthony]

I am aware that I cross-posted (not frowned upon) rather than multi-posted
(frowned upon)

How do I read and write data to a text file?

Also, How do I "query" the text file and have it retreive a specific line,
so I can edit THAT LINE?

example:

What if my text file looks like this:


Bob, 399
Joe, 293
Suzy, 300
Henry, 201
Dufous, 041
Dork, 003


And I want to access the "Suzy" line and change the value from 300 to 293?

How do I do this with VBA?

Grawsheeus

 

[bob]

This is a good place to start:

http://www.microsoft.com/technet/scriptcenter/resources/qanda/textfiles.mspx

Try also: http://www.vba-programmer.com

Note that you may want to add a reference to the Microsoft Scripting Runtime
to use some of these techniques via VBA

Bob

 

[Geoff]

Anthony,

If you wanted to explore a ready-made solution, there is code for a TextFile
class module in the "Access Developers Handbook" by Getz, Litwin and
Gilbert. It's used to introduce the topic of class modules.

Geoff