|Sort by date
|File access with VBA
|VBA provides functions for performing file input/output (I/O). This lets your custom solutions create, edit and store large amounts of data.
|Log error-messages and other useful information in a text file that can be read later.
|Replace text in a text file
|This example can be used to replace text in a text file, e.g. when you want to change a column separator in a text file before you import it into an Excel worksheet or after you export a worksheet to a text file.
|Using binary file access
|With binary access it's possible to store information in any way you want, you are not limitied to a fixed record length. This means that you have to know how the information is stored in a binary file to retrieve it again.
|Using Microsoft Scripting Runtime
|It is possible to use the Microsoft Scripting Runtime library to manipulate text files.
|Using random access
|A random access file is assumed to contain a series of records of equal length. This makes it easy and quick to locate stored information. Random access files can use less diskspace compared to sequential files.
|Using sequential access
|Sequential access is used for writing and reading text files, such as error logs and reports, e.g. *.txt files, *.ini files and *.csv files. Sequential access files are easy to create and manipulate with text editors, most applications can read an