Business solutions Automating Microsoft

20. Working with Data Files

IN THIS CHAPTER

Understanding File I/O

Opening Files

Reading from Files

Writing to Files

Printing to 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 ...