Microsoft® Office Excel 2003 Programming Inside Out

Chapter 13. Manipulating Files

Locating External Files

Writing to an External File

Reading from an External File

Searching a File for a Value

Many applications that you develop for Microsoft Excel require working with multiple files. For example, you might need to get a listing of files in a directory, delete files, or rename files. Excel, of course, can import and export several types of text files. In many cases, however, Excel’s built-in text file handling is not sufficient. For example, you might need to import a text file that contains more than 256 columns of data, which is Excel’s limit, or the file might use a nonstandard delimiter such as a backward slash (\).

In this chapter, you’ll learn how to locate, write to, and read from external ...