ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: 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. 1999-12-17
Log files Log error-messages and other useful information in a text file that can be read later. 2000-11-02
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. 1999-12-17
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. 1999-12-17
Using Microsoft Scripting Runtime It is possible to use the Microsoft Scripting Runtime library to manipulate text files. 1999-12-17
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. 1999-12-17
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 1999-12-17
Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address