Using VBA File IO Methods

In addition to the Open(), Save(), and SaveAs() methods of the Workbooks, Workbook, and Worksheet objects, VBA and its associated object libraries include several I/O objects such as the Dialogs, FileDialog, FileSystem, and FileSystemObject objects, and other subordinate objects. Some of these objects are conceptually more difficult to use and therefore will not be discussed in this chapter; however, I will show you how to use one object from the Office library and VBA's Open statement for adding file I/O to your programs.

An Excel worksheet after saving as a text file (.csv extension).

An Excel worksheet after saving as a text file (.csv extension).

The text file that results from saving the worksheet in Figure 7.10.

The text file that results from saving the worksheet in Figure 7.10.

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment