Skip to Main Content
Business Solutions VBA and Macros for Microsoft® Office Excel® 2007
book

Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

by Bill Jelen, Tracy Syrstad
August 2007
Beginner to intermediate content levelBeginner to intermediate
624 pages
14h 46m
English
Que
Content preview from Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 20. Text File Processing

IN THIS CHAPTER

Despite the promise in Chapter 17, “XML in Excel 2007,” that XML will be the next great file format of the future, we still have a lot of files in CSV or TXT file format today.

VBA makes it easy to both read and write from text files. This chapter covers importing from a text file and writing to a text file. Being able to write to a text file proves useful when you need to write out data for another system to read, or even when you need to produce HTML files.

Importing from Text Files

There are two basic scenarios when reading from text files. If the file contains fewer than 1,048,576 records, it is easy to import the file using the Workbooks.OpenText ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Solutions VBA for the 2007 Microsoft Office System

Business Solutions VBA for the 2007 Microsoft Office System

Paul McFedries

Publisher Resources

ISBN: 9780789736826Purchase book