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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.