How to edit a text file from vba (1 Viewer)
- Thread starter AccessKid
- Start date
ritchieroo
Registered User.
- Local time
- Today, 19:32
- Joined
- Aug 2, 2002
- Messages
- 80
Traditional VB I/O method...
Dim hFile as Long
Dim sLine as String
hFile = FreeFile
Open "c:\Whatever.txt" For Random As #hFile
Do Until EOF(hFile)
Line Input #hFile, sLine
'... Process sLine
Loop
Close #hFile
There are also more up to date methods such as TextStream objects whixh are a little easier to use, but no more efficient on the whole.
You can get a TextStream object by setting a reference to the "Microsoft Scripting Runtime" library. After creating a new FileSystemObject, use the OpenTextFile method to open and manipulate your file.
If you're used to using ADO, it offers a Stream object that can be used to do the same sort of things. It's character set aware, and can fix issues such as Chr(13) being used to end lines rather than Chr(13) & Chr(10) automatically. But all this added functionality can make it trickier to use.
Dim hFile as Long
Dim sLine as String
hFile = FreeFile
Open "c:\Whatever.txt" For Random As #hFile
Do Until EOF(hFile)
Line Input #hFile, sLine
'... Process sLine
Loop
Close #hFile
There are also more up to date methods such as TextStream objects whixh are a little easier to use, but no more efficient on the whole.
You can get a TextStream object by setting a reference to the "Microsoft Scripting Runtime" library. After creating a new FileSystemObject, use the OpenTextFile method to open and manipulate your file.
If you're used to using ADO, it offers a Stream object that can be used to do the same sort of things. It's character set aware, and can fix issues such as Chr(13) being used to end lines rather than Chr(13) & Chr(10) automatically. But all this added functionality can make it trickier to use.
- Local time
- Today, 14:32
- Joined
- Feb 19, 2002
- Messages
- 43,461
You can't update a sequential file. You can only add records to the end of it.
To modify a sequential file, you will need to read it and write each record to a new copy of the file, making changes as you go.
To modify a sequential file, you will need to read it and write each record to a new copy of the file, making changes as you go.
