20. Working with Data Files

Understanding File I/O

The term file I/O refers to file input and output functions, which is one way to manipulate the contents of a file. Although you might never use I/O functions, you might run into them in legacy applications that you must support.

The VBA I/O process is simple:

• Use the VBA Open function to open a file.

• Use the VBA Input function to retrieve a file’s contents.

• Use the VBA Write function to write to a file.

• Use the VBA Print function to write a series of values to an open file.

Before you can use I/O to manipulate a file’s contents, you need to know the file’s handle. Within this ...

Get Business solutions Automating Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.